GY12_Word_31Dec20_Word2_d1.10_G12_1234 I have 7 to 9 delimited(_) string and I want to determine if each delimit is in proper format/appropriate value I am using regex tokenize but for some reason it doesn't seem to work Current ValueHow to check if it's correctGY20First two letters should be GY followed by two digit number 18 to current last two digit of yearWordAny word must not contain special characters excluding period and underscore.31Dec20\d{2}\w+\d{2,4}Word2Contains word 'Licensing' or any 3 character lengthd1.10left must be lowercase of v and second number must be a period.G12G\d{1,2}1234\d{3,4} is it possible for this to be written in one regex expression or should do split to columns then do each regex expression?

Help! Regex Tokenize multiple expression

GY12_Word_31Dec20_Word2_d1.10_G12_1234

I have 7 to 9 delimited(_) string and I want to determine if each delimit is in proper format/appropriate value

I am using regex tokenize but for some reason it doesn't seem to work

Current Value	How to check if it's correct
GY20	First two letters should be GY followed by two digit number 18 to current last two digit of year
Word	Any word must not contain special characters excluding period and underscore.
31Dec20	\d{2}\w+\d{2,4}
Word2	Contains word 'Licensing' or any 3 character length
d1.10	left must be lowercase of v and second number must be a period.
G12	G\d{1,2}
1234	\d{3,4}

is it possible for this to be written in one regex expression or should do split to columns then do each regex expression?

Transformation

Accepted answers

Tyro_abc

Another try, might need some more fine-tuning but working with my sample data.

(GY[1-2][\d])_(\w+)_(\d{2}[a-zA-Z]{3}\d{2,4})_(Licensing|[A-Z]{3})_(\l\d\.\d{2})_(G\d{1,2})_(\d{3,4})

Regards

Arundhuti

Regex.yxmd

All comments

Tyro_abc

Spoiler

attached workflow

Regards
Arundhuti

Text to Column tool.yxmd

Ultralightbeam

@Tyro_abc I need to get the correct pattern for each since the pattern for each row is different.

Qiu

@Ultralightbeam

It seems you should use RegMatch instead.

However, you said there are 7 to 9 delimited(_) , which make thing complicated.

Do we have fixed pattern for the 7, 8, 9 cases seperately?

Ultralightbeam

@Qiu

basically instances where there are 7 to 9 delimited is based from the word1 sometimes word1 got two delimited which can be concatenated into one.

original and standard format GY12_Word_31Dec20_Word2_d1.10_G12_1234 - 7 delimiter

sometimes

Like GY12_Word_Word.1_Word.2_31Dec20_Word2_d1.10_G12_1234

Therefor Word_Word.1_word.2 must be in one pattern Any word must not contain special characters excluding period and underscore. (there is really no pattern for this) thinking of just doing (\w+)

Tyro_abc

Another try, might need some more fine-tuning but working with my sample data.

(GY[1-2][\d])_(\w+)_(\d{2}[a-zA-Z]{3}\d{2,4})_(Licensing|[A-Z]{3})_(\l\d\.\d{2})_(G\d{1,2})_(\d{3,4})

Regards

Arundhuti

Regex.yxmd

Ultralightbeam

@Tyro_abc it's working

For Regexout2 it only gets words is it possible if we can also add special characters and numbers since its really a company name which may include parentheesis. Thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703