Very urgent

Hi Support,

I have a file with Values filled as Below.

Name,Test
Age,50
X1,Y1
X2,y2

i need to pass one by one value to the variable.

For Example:

Automatically system should pass value to a variable Data

  1. Data = Name
  2. Data = 50 …
    etc.

it should continue until the last value of the item 2 of each line of file.

PLease help me to do this!!!

I don’t really understand your request. What do you mean by:

i need to pass one by one value to the variable.

You say your file contains:

Name,Test
Age,50
X1,Y1
X2,y2

but your example is:

  1. Data = Name
  1. Data = 50 …
    etc.

What happened to “Test” and “Age”? It would seem that Name is a field and Test is its value, so why are you putting everything into Data? None of this really makes sense.

Hi ,
you can store the values from a file into variable using commands below:

Age,50
X1,Y1
X2,y2

  1. Save your file name with path into a variable:

Put “D:\TestFile.csv” into FileName

Read contents and store it in variables;

Put item 1 of line 2 of the FileName into Var1
Put item 2 of line 2 of the FileName into Var2
Put Item 1 of Line 3 of the FileName into Var3
Put item 2 of Line 3 of the FileName into Var4

Result:
Var1 -->X1
Var2–>Y1
Var3–>X2
Var4–>Y2