Hi,
How do I use a formula or tool to Find and remove part of a string. Thanks.
EXAMPLE: I want to remove all string after "STE", include STE
105 W Madison St STE 101
100 Westminster St STE 1050
Output
105 W Madison St
100 Westminster St
Solved! Go to Solution.
Hi @BosKev,
You could use TRIM(REGEX_Replace([Text], '(.*)STE.*', '$1'))
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
Thank you!
Hi @BosKev,
you could use the Regex_Replace Function in the formula tool to do this:
Formula:
REGEX_Replace([String], '\s[A-Z]+\s', ' ',0)
Output:
Sample workflow attached. Let me know what you think.
Best
Alex