AnsweredAssumed Answered

Convert bullets in text field to unordered html.

Question asked by kevin2001arba on Jul 17, 2014
Latest reply on Jul 17, 2014 by 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.

      

Outcomes