I have a file that contains 3 fields in every line separated by a coma, and I need to read the first field and then put on the web form, then come back to the file and read the next field on the same line and do the same, and return for the last time and grab the third field on the line and do the same, then go to line 2 and do the same over and over until EOF. Here is a sample of the file.
12345,3434,33333
34557,9898,87878
43409,3349,93753
Read a text file with 3 fields for line
Moderators: Dorian (MJT support), JRL
- Marcus Tettmar
- Site Admin
- Posts: 7395
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Read a text file with 3 fields for line
Can you not use CSVFileToArray?
Alternatively use ReadFile and then use the Separate command to split on CRLF. Loop through that array and for each entry use Separate again and split on COMMA.
Alternatively use ReadFile and then use the Separate command to split on CRLF. Loop through that array and for each entry use Separate again and split on COMMA.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?