Find upper string and Remove

[BosKev]

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

[Jonathan-Sherman · Accepted 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

[BosKev]

Thank you!

[grossal]

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