2 Replies Latest reply: Oct 13, 2016 7:35 PM by Marco Wedel RSS

    Mapping load help

    Steve Lord

      Hi All, I have text strings with commas I need to map to text strings without commas.  Please advise.  Thanks!

       

      Example:

      I want this:

      Acme 2016 - Walk 10,000 Steps - March

      to go to this:

      Acme 2016 - Walk 10000 Steps March

       

      But the comma in the first 10,000 breaks the mapping for that line.

       

      I have a mapping load with several hundred rows of stuff stripping the second hyphen to help a subfield action in a dashboard, but the commas in the last few strings are holdouts.