Hi Andrew,

if all you need is an array, you can borrow the of_parsetoarray function from the PFC string helper class, it splits a string into an array with a given delimiter. Just look for the tab character for each line with Pos() and remove the left part first.

This will create a string array; if you need a number array instead, you should be able to easily adapt the function to convert each value to a number first.

Hi Andrew;

  FWIW: I would create an external Datawindow with columns to match your CSV fields & then simply use the ImportFile() command. Quick & simple IMHO.

HTH

Regards ... Chris 

Hi,

I would try to:

1. Read all of the file contents using FileReadEx or if you prefer FileRead line by line

2. Convert the obtained blob into a string and  replace all of the commas with a TAB character ("~t")

3. Create an external datawindow with a field "code" of type char(4) and 19 other fields "value01, value02, ...... value18, value19 of type number.

4. Use ImportString() to import the string into your datastore / datawindow (or first write everything to a file and then use ImportFile() ).

regards.