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!!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels