Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

What is the expression to set the RegEx tool to replace everything before a character?

hellyars
13 - Pulsar

I forgot how to do this.

 

I want to remove the outline sequence before an item's name.

 

How do I set up the expression in the RegEx tool to repack or get rid of the outline reference.  Note, this is just an example.  The real data might include 2.1.3, 1.1.5, etc.

 

Item-->Item
1.1.1) Chassis Chassis
3 REPLIES 3
ivoller
12 - Quasar

Something like REGEX_Replace([Item], "\d.\d.\d\) ", "")

jdunkerley79
ACE Emeritus
ACE Emeritus

I'd try something like:

 

REGEX_Replace([Item],"^.*?([A-Za-z].*)$","$1")

Which will match the first character and replace all before

hellyars
13 - Pulsar

They both work. 

 

I modified the first to include \s to get rid of the space between the outline position and the name.

 

Thanks!!

Labels