I'm new and struggling. I am trying to data cleanse columns of data that say 'USA-Senior Associate' and 'USA-Competency' and I would like to remove the 'USA-' from both sets. How do I do this?
Thanks
@BenMoss,
Windex! Get something to clean those glasses.
Replace([_CurrentField], "USA-", '')
What could be easier than this formula (which by the way will work nicely in a multi-field formula tool.
Cheers,
Mark
So I have inserted the multi-field formula after my import of data.
I selected both columns (V-strings) that I would like to start with (as you guessed there are many that need the 'USA-' gone).The Copy Output Fields Add box is already checked so I left it alone (it says 'New_ as a prefix).
I tried your formula and I tried Replace([_CurrentField_], "USA-", "") and neither of those seem to be doing anything. I did it in the single formula option and did get it to work - but I would love to learn how to use this multi-formula instead of cheating and doing 3-4 formulas right after each other.
Be sure to either scroll right in your results window, or deselect the option 'Copy output fields Add'. If you have this option checked it will create as many knew fields as those selected which will be added to the right side of your table, commonly out of view.
Ben
You could also simply pad the first 4 characters out.
