Hi
I need to remove the string text "BUORG" and then the next string, whatever that may be, that has underscores in all the columns but can't work out how to do that. Any ideas?
Source
Business Unit | Business Unit Level 2 Description | Business Unit Level 3 Description | Business Unit Level 4 Description | Business Unit Level 5 Description |
FGAEQ | BUORG ORG_MFG MAT ASSET MANAGEMENT | BUORG ORG_MFG_MAT MAT INVESTMENT MANAGEMENT | BUORG ORG_MFG_ASIA MIP ASIA | BUORG ORG_MFG_ASIA_EQ EQUITIES |
Final
Business Unit | Business Unit Level 2 Description | Business Unit Level 3 Description | Business Unit Level 4 Description | Business Unit Level 5 Description |
FGAEQ | MAT ASSET MANAGEMENT | MAT INVESTMENT MANAGEMENT | MIP ASIA | EQUITIES |
Solved! Go to Solution.
@nsarayar try this in a multi field formula tool, ticking the columns you want:
TRIM(REGEX_REPLACE([_currentfield_],'BUORG \w+',''))
This will replace all letters, numbers and underscores following BUORG with nothing
Hi @nsarayar
You can use multi-field formula tool and regex_replace for this usecase.
Workflow:
Edit : I updated my solution after seeing @OllieClarke response 😅 now its the same.
Hope this helps : )
Hi @OllieClarke
Interesting i didn't know \w includes underscore _. I checked now in the Regex tool to confirm after seeing your response.
Thank you for the share 🙂
Thank you!
Happy to help : ) @nsarayar
Cheers and have a nice day!