Thank you for your post.
I created a .csv file with a FileMaker Pro 12 database. That file contained 2 fields and 5 records with a combination of text, quotation marks and commas in every record and every field. I then imported that .csv file into a second FileMaker Pro 12 database with “All Available” for the file type selected.
I got two source fields of data and imported into the two fields designated to match. I tested on both 10.7.4 and 10.8.
Am I possibly missing a step to reproduce the issue?
I'm wondering if there's something in the csv file being generated by my "mainframe" as it's those files that are having issues, not being recognized correctly.
just did another test..... maybe it's not files with the csv extension, but a txt extension.
I just tried with another file. comma delimited but with a txt extension. all fields per record imported into one field. change the extension from txt to csv and it imported correctly. still using the all available files option.
So I must have not payed close attention to the extensions.
That said, I know that in FMP 11, i never had it import into one field like it does now.
Thanks for checkin and responding on this.
I have the same issue but only with tab files. In 11, if I had a "tab" ending on the file it imported correctly. In 12, a txt and tab file are imported as a coma delineated file if you don't specifically select the file type as tab in the import dialog box.