Jump to content

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


freefighter
 Share

This topic is 5700 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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¿

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5700 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.