Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

how to use replace formula

8 - Asteroid

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

13 - Pulsar

Try this, should do the trick:


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

 Hope it helps!

8 - Asteroid

Thank you very much.