How to change the list seperator from comma to semicolon in FMP8.5

[freefighter]

I have a csv file using semicolon as the tab seperator, consisting of 300.000 lines and 16 columns; which is the reason why I cant view the file through MsExcel due to the 65.536 lines restriction in Excel. So I am trying to import the file to FMP but FMP doesnt recognize semicolon (: as list seperator. So I can view all data of 16 columns in the same column. I dont know how to change the setting for this. Any solutions¿

[IdealData]

In true parlance this is not a CSV file (Comma Separated Values) as you have used a ";" as your separator.

Use a text processor (Word, Open Office) to open the file and transform it.

[Brudderman]

After importing into FM into a single column, you might try replacing the semicolon with a comma, exporting as CSV to a CSV file and then reimporting.

[comment]

I don't think that would work, because during export Filemaker will protect the in-field commas by wrapping the entire field contents in quotes. However, it should be simple enough to split the imported field, either by script or by 16 calculation fields, using the semi-colons as markers.

[Genx]

Seriously, open it in NotePad, Replace > Find What (enter: ; ), Replace With (enter: ,) then click the replace all button. Now import your new file.