![]() There is no prescribed escaping mechanism. Data NEEDS to be double-quote encapsulated ONLY if the field or record separator is present in the data.The record separator can be CR, LF or CR-LF.I've written CSV exporters and parsers in C. I will skip 1 when I need a field separator other than comma.Ī little more info on the CSV file format… Use a calculation field to generate the record data, collate the data then write the data to file.Use a calculation field to generate the record data, collate the data then export the field data to file.Use a calculation field to generate the record data then export that field in a tab-delimited file.Record export and let FileMaker handle the complexity for me.Post some sample data and I'll be happy to help! gives you a single point of update for 1 software client or for 10,000.Ĭreating CSV is a standard thing that has been solved many ways. Since I work with multiple environments, code I write generally is wanted by more than one software client like FMP. Programmatically with micro-service: POST the text to export to a little micro-service method you write (I've written tons of these so I could give you some sample code if you're interested) that writes the CSV any way you like. Programmatically with JDBC, and FMI's free JDBC driver, you could issue the same SQL you did interactively in "1." above, and just write simple CSV export code (examples all over the py and paste code mostly). Do a SQL statement on a FileMaker database (easy to set up using FMI's free JDBC driver) and then choose to export CSV. Interactively: You can use a third-party tool like razorsql or even an "IDE". A few other ways to get CSV from FileMaker.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |