Reading a csv file in PAC control

Mary has an example of parsing a file here:

With few modifications of the above code you should be able to parse down into individual rows (or use the ReceiveStrTable command as Mary mentioned and loop through the string table). Once you have a single row, you will need to parse the individual rows for the comma, convert from string to float (there’s a command for that) and then store in your table.

I have a subroutine I use to parse strings that takes a delimiter as a parameter and a position and returns the parsed item which will help with parsing at the row level:

ParseDelimitedString.zip (1.2 KB)

You would call it like this:
ParseDelimitedString(MyRow, “,”, 1, FirstColumnValue);
ParseDelimitedString(MyRow, “,”, 2, SecondColumnValue);

This returns strings, so you will then use the StringToFloat command and store in your table.

Good luck!