community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

how to use replace formula

Highlighted

Hello, can anyone teach me how to take away the mess words away which are both at beginning and end tail from the company name that I mark in Red color, what formula should I use to take them away?

 

<a href="/apex/salesaccountexplorer?id=0013000001FvC7Z" target="_blank">Taylor Fracasse Architecture Inc</a>

 

 

thank you

Pulsar

Try this, should do the trick:

 

REGEX_Replace([Field1], '<.*?>', '')

 Hope it helps!

Thank you very much.

Labels