1 Reply Latest reply on May 4, 2012 3:46 PM by philmodjunk

    Changing Delimiter

    wbanks

      Title

      Changing Delimiter

      Post

      I'm using FM11.

      I'm attempting to load a file that contians the pipe delimiter.  Is there a place where I can change the default delimiters?

      Thanks.

        • 1. Re: Changing Delimiter
          philmodjunk

          Please explain what you mean by "load a file". Are you importing a csv file that uses | instead of ,?

          Assuming that us what you mean....

          At this time, there is no built in option with Import records for specifying a different delimitter than ",".

          You can either use a text editor to change the delimitters into commas or import the data into an iterim table in FileMaker and then use a script to parse the data into various fields in your target table.