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
SOLVED

how to use replace formula

Highlighted
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

Highlighted
13 - Pulsar

Try this, should do the trick:

 

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

 Hope it helps!

Highlighted
8 - Asteroid

Thank you very much.

Labels