2 Replies Latest reply on Apr 19, 2013 11:15 AM by rickaltman

    Separating Paragraphs in a Field



      Separating Paragraphs in a Field


           I have a field that has four small paragraphs in it, like this:

           Paragraph 1

           Paragraph 2

           Paragraph 3

           Paragraph 4

           I need to export that field so that each paragraph has a prefix before it (not just a prefix before the entire field, which would be easy). Is there a formula that can sniff out the beginning of paragraphs within a field and insert prefixes before them (in my case "@00=")?

           Many thanks.
           Rick A.
           Pleasanton CA