This content has been marked as final. Show 2 replies
Hi All, I have text strings with commas I need to map to text strings without commas. Please advise. Thanks!
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.