FileMaker Pro 10 cannot use "pipe" "|" as delimiter when importing or exporting files
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.