Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Requesting help with Regex

Manjari_T
8 - Asteroid

Requesting help with Regex

Is there a way to get the the column "Name needed" from Column Name

NameName needed
Chocolate groupsChocolate
Chocolate CoChocolate
Chocolate ltdChocolate
Vanilla infotechVanilla infotech
Clip SOLUTIONS LTDClip
Clip CoClip
Clip groupClip
M limitedM limited
ChocolateChocolate
messi007
12 - Quasar

@Manjari_T,

 

In this case I think you need a formula not a Regex. As there's not a fixed pattern for the Regex

 

messi007_0-1613980910000.png

 

Attached the workflow,

 

Regards,

 

Manjari_T
8 - Asteroid

Thank you @messi007 

But I have 10000 rows of many different listings like below.

messi007
12 - Quasar

@Manjari_T,

 

Below the Regex, but you have to deal with other case like Vanilla infotech with a formula.

 

messi007_0-1613982805365.png

Hope this helps,

 

Regards,

afv2688
15 - Aurora
15 - Aurora

Hello @Manjari_T ,

 

I've written a little solution with the fuzzy match tool, hope it helps.

 

Untitled.png

 

Regards

BretCarr
9 - Comet

@Manjari_T 

what are all the different situations where you need more than the first word? Is it only a handful? I can probably zap together a REGEX pattern for you but what is determining the criteria? It feels like we haven’t been given enough here to suss out what you are looking to accomplish.

 

Can you provide more sample data or is your provided scenario the extent of all the different possible situations that happen?


Bret

BretCarr
9 - Comet

If these are your only scenarios, this REGEX will work to parse your list:

((?:Chocolate|Clip|M limited|Vanilla infotech))

 Cheers!

Labels