Remove string phrase that has underscores

nsarayar

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

OllieClarke

@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