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.
Solved! Go to Solution.
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.
@franciscoruizrise Use Text To Columns in the Parse tools. Type a space as the delimiter . Select 3 columns.
@DataNewBand @BS_THE_ANALYST Thank you, I was able to solve this with your help.