Need to Trim the first section of a string vale.

Question

Hello community,

I'm new to using the RegEx tool in Alteryx and wanted to ask for help regarding a situation.

In the company I work, we have our department names starting with a:

Numeric code (three digits, depending on the department) + Company Name + Department Name

Ex.:

178 ABC Project Management
182 ABC Social
192 ABC Digital Strategy

The numeric value at the start always has three digits but that could change in the future to four digits.

-> I'm needing to remove the digits and Company Name at the start to leave only the Department Name:

Output desire:

Project Management
Social
Digital Strategy

Can you help me to solve for this situation?

Regards,

Francisco.

DataNath · Accepted Answer

Hey @franciscoruizrise, if by company name you mean your own and it's consistent throughout then you could use a simple expression like so:

Just replace 'The Information Lab' with your own company, making sure you keep the extra space afterwards i.e. 'ABC (.+)' or 'Amazon (.+)' etc.

BS_THE_ANALYST · Accepted Answer

@franciscoruizrise Use Text To Columns in the Parse tools. Type a space as the delimiter . Select 3 columns.