12 Replies Latest reply on Jul 17, 2014 11:21 AM by kevin2001arba

    Convert bullets in text field to unordered html.

    kevin2001arba

      Title

      Convert bullets in text field to unordered html.

      Post

           Hopefully a text parsing wizard can help with my calculation. I am trying to change this:

            

           • Highly Nutritious
           • Economical
           • Organic

           Part of a nutritious routine that will benefit your pet. Available in three sizes. Please read directions prior to use.

            

           to this:

            

            

           <ul>
           <li>Highly Nutritious</li>
           <li>Economical</li>
           <li>Organic</li>
           </ul>
           <br>
           Part of a nutritious routine that will benefit your pet. Available in three sizes. Please read directions prior to use.
            
           I started with this:
            
            Substitute(ListField;["•";"<ul>¶<li>"];["•";"<li>"])
            
           But I cant seem to understand how to use the position function with the substitute function.