2 Replies Latest reply on Jul 10, 2014 1:14 PM by CarlisleLandel

    Importing carriage returns in a .csv file

    CarlisleLandel

      Title

      Importing carriage returns in a .csv file

      Post

           I've got some MS word forms, the data in which can be saved as a .csv file, which then gets imported via script.

           How do I get a carriage return in the .csv to import within its text filed reliably?  Sometimes the whole field goes into the correct space, and sometimes the data beyond the carriage return goes into the next field, shifting everything out of register for the rest of the import. I can't figure out the rules the program uses to decide whether to keep the return within a field or shift it into the next.  Does anybody know the trick?

           I'm still using FMP12, by the way.

           Thanks.

        • 1. Re: Importing carriage returns in a .csv file
          philmodjunk

               There is more than one character that can be used as a "return character". My guess is that some of your "returns" are one character and the others are a different character. In MS Word, for example, pressing the Enter (return on a Mac) key inserts on character and holding down the shift key while pressing enter inserts a different character. FileMaker then interprets the one character as a "Field" or "Record" separator and not the other.

               You may want to click the ¶ button in MS Word and examine the data you want to import there to see if you see different symbols used for the invisible "return" characters.

          • 2. Re: Importing carriage returns in a .csv file
            CarlisleLandel

                 Hey,

                 Thanks for the quick response.  I think I finally figured it out myself.  It simply has to do with how you encode the files in MS word.  If you don't pay attention there, the individual lines get encased with quotation marks and separated by commas, and FMP does what it is supposed to do and interprets this exactly as it is supposed to do.

                 In other words, its a problem in Word, not FMP.  Go figure.cheeky

                 Thanks!

                 Carlisle