Looking for some clarification on Datasets
Alright, I need to read in a csv file that contains several lines. The delimiter is ^. This file holds one line that has the header information for a sales order. The subsequent lines are individual line items (1-many). How can I read one line at a time and end when I reach the end of the file? I would be reading the line into a string and split it from there.
In that case, you can read the lines of file in Text mode. Get the line into a string and then use SPLIT command to split the values at '^' into the table fields.