0 Replies Latest reply on Aug 5, 2011 9:04 AM by PhilipDouglas

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

    PhilipDouglas

      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.