Imacros colums

My script look like:

SET !DATASOURCE test.csv
SET !DATASOURCE_COLUMNS 2
SET !LOOP 1
SET !DATASOURCE_LINE {{!LOOP}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:createaccount ATTR=ID:LastName CONTENT={{!COL1}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:createaccount ATTR=ID:EmailAddress CONTENT={{!COL2}}


And my test.csv looks like:


And when i start my macro, in "LastName" i have "1;a" not only "1".. What i doing wrong ?

I think you need , not ; to separate fields

yea, that's tricky a bit , i remember having the same problem, unfortunately i don't remember the exact solution, but one thing is sure, you need to make the columns in your .csv comma separated like this: you can try doing it in excel or with notepad and saving the document as .csv, i'm not 100% sure, but i remember doing it with notepad because if i did it in excel it didn't work for some reason

try it, it should work

Hmm.. i know where is the problem..

new column in excel create ";" separate, not ",".. How to change that ?