Help! Regex Tokenize multiple expression

[Ultralightbeam]

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?

[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

[Tyro_abc]

At last some progress.

How about this? I added few characters like parenthesis, dot & etc., and seems to be working, please check once.

Regards

Arundhuti

[Ultralightbeam]

thank you!! i have added dash and it's working.

Is it possible to use | on regex if pattern may be consist of the following

on d1.10

in some instance it has d.1.10

some has no d but  1.10

doesnt really matter if first letter is in uppercase or lowercase

is it possible to capture all of that format in one expression under regex5out? Thank you very much

[Tyro_abc]

I was able to make that character optional and it would accept both upper and lower case.

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