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
Just to throw another option in there (SO many ways to do things in Alteryx), and keeping in the vein of the using the Multi_Field Formula Tool to clean several fields;
Substring([_CurrrentField_],FindString([_CurrentField_],"-")+1)
Findstring finds the 0 based position of the -
Substring starts at the character after the - and takes the rest of the string
This would work if you have other prefixes besides USA
I'm using _CurrentField_ here as that's the format of the Multi_field Formula tool - in a standard formula tool replace it with the field name.
Bob
You could also simply pad the first 4 characters out.
