Help needed reading values of a csv-file into variables

migro · Post by **migro** » Sun Dec 02, 2007 5:41 pm

Hi,

I need some help, reading Informations from a csv-file line by line into Variables.

csv-example:
1;Morgan;Peter;20.03.1983 00:00
20;Miller;John;21.03.1985 00:00
312;Smith;Suzanne;12.08.1993 00:00
....

I got 4 Variables: ID, Name; Forename and Birthday.
I tried it with the Positon- and Midstring-Command but can not get it working.

Thanks for the help

Post by **Marcus Tettmar** » Sun Dec 02, 2007 6:13 pm

Use Separate:

Separate>line,;,fields
MessageModal>fields_1
MessageModal>fields_2
MessageModal>fields_3
etc

See:
http://www.mjtnet.com/blog/2007/07/02/m ... xcel-data/

migro · Post by **migro** » Sun Dec 02, 2007 6:54 pm

Thanks a lot, it works