Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Requesting help with Regex

Manjari
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
6 REPLIES 6
messi007
15 - Aurora
15 - Aurora

@Manjari,

 

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
8 - Asteroid

Thank you @messi007 

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

messi007
15 - Aurora
15 - Aurora

@Manjari,

 

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
16 - Nebula
16 - Nebula

Hello @Manjari ,

 

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

 

Untitled.png

 

Regards

BretCarr
10 - Fireball

@Manjari 

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
10 - Fireball

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

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

 Cheers!

Labels