Using RegEx_replace to match certain pattern

[rgmaier]

Hello,

I have a simple issue: Using Alteryx, I want to take a string, match a certain pattern and return the matched pattern.

This is my current approach:

ConsumerProducts&Retail</td><td><strong><fontcl

According to various sources and tools like regex101, the first matched sequence should be "CP:ConsumerProducts&Retail". However, Alteryx returns "<<<<". I am absolutely confused why it does that.

[ivoller]

Can you share a sample workflow? I'm not really sure what you're seeing here.

[rgmaier]

Please find my sample workflow attached.

[ivoller · Accepted solution]

Try:

Regex_Replace([Input],"([^\<]+).*","$1")

This will find the first string not containing the characters you exclude and save to $1.