GET the date from multiple columns

[Ultralightbeam]

Column1	Column2	Columne3	Output
[Null]	31Dec20	23	31Dec20
31Mar2020	32	LoremIpsum	31Mar20

Hello, I have 3 columns and output is going to get the date between three columns, however the date format between all three columns are different some have (%d%b%y) and some have (%d%b%Y). Just different in year some have 2020 and some have only 20.

[Qiu · Accepted solution]

@Ultralightbeam 
Your month was 3-characters only. Now modified to any length of characters.

[Ultralightbeam]

@Qiu , its now working just not getting 1 digit day lol. May I know what's the meaning of regex 

\d{2}\w+\d{2,4}

I think d stands for digits and w for words? bracket dictates that it should only consist of 2 length or 2 up to 4 in length, please correct me if i am wrong. 

[Qiu]

@Ultralightbeam 
Yes, your understanding is correct👌

I usually use this this site to learn and check my RegEx.

https://regex101.com/

[Ultralightbeam]

@Qiu I used 

REGEX_Match([Value], '\d{1,2}\w+\d{2,4}')

so if 2June20 or 02June20 day if with leading 0 or not will still stay as true, however  including string is going into true now

[Qiu]

@Ultralightbeam 
Can you give me a snapshot?

[Ultralightbeam]

@Qiu 

It's going into the left part of join since day is only 1 digit

[Qiu]

@Ultralightbeam 

It is weired since it works just fine on my end.