Mapping load help

[stevelord]

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.

[stevelord]

Just googled and found people say use single or double quotes around the string.  (It was an inline load example, but should be fine.)

[MarcoWedel]

please provide some more sample data of your mapping table and raw data yo uwant to apply the map to.

Relevant parts of your script might help as well.

regards

Marco