4 Replies Latest reply on May 12, 2010 7:12 AM by jmoorma2

    Removing Carriage Returns

    jmoorma2

      Title

      Removing Carriage Returns

      Post

      I am new to FileMaker using FileMaker Pro 10.

       

      I have a Calculation field using the List function. In the List function it seperates data using carriage returns, how do I get rid of the carriage returns? For example, I want to go from my data looking like the following:

       

                        Black

                        Red

                        Green

                        Blue

       

      and I want it to look like the following:

       

                       Black; Red; Green; Blue

       

       

      Is this possible? If so, please help.

       

       

      Thanks!