AnsweredAssumed Answered

FileMaker Pro 10 cannot use "pipe" "|" as delimiter when importing or exporting files

Question asked by PhilipDouglas on Aug 5, 2011

Title

FileMaker Pro 10 cannot use "pipe" "|" as delimiter when importing or exporting files

Post

I have a customer that sends me text files. They are multi-lined and delimited with pipes. I cannot import these into FileMaker Pro 10 unless I first open the file in Wordpad and replace pipes with commas. However, this is a problem because when I have to send the files back I have to replace the commas with a pipe. If a field contained a full person's name that also had commas in it, it screws everything up. These databases have a couple hundred fields in each.

Outcomes