Requesting help with Regex
Is there a way to get the the column "Name needed" from Column Name
Name | Name needed |
Chocolate groups | Chocolate |
Chocolate Co | Chocolate |
Chocolate ltd | Chocolate |
Vanilla infotech | Vanilla infotech |
Clip SOLUTIONS LTD | Clip |
Clip Co | Clip |
Clip group | Clip |
M limited | M limited |
Chocolate | Chocolate |
In this case I think you need a formula not a Regex. As there's not a fixed pattern for the Regex
Attached the workflow,
Regards,
Thank you @messi007
But I have 10000 rows of many different listings like below.
Below the Regex, but you have to deal with other case like Vanilla infotech with a formula.
Hope this helps,
Regards,
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
If these are your only scenarios, this REGEX will work to parse your list:
((?:Chocolate|Clip|M limited|Vanilla infotech))
Cheers!