Extract Date

bubblyjai1982

Hi All

I’m trying to extract the “Date” from Sec Id column.

For Example: AERTUSD052726EQINL01 contain Maturity date is 27-05-26

The challenge is Sec id does not have fixed character to cut the date.

Kindly assist if there is any possibility to grab Date which are in numerical character but not fixed character

For your reference attached data.

Thanks in advance !!

Extract date.xlsx

davidskaife

Hi @bubblyjai1982 

You can use Regex Tool and Parse output method using the below code to extract the numbers from the string, but, how do you tell if the output should be year 1930 or 1931 as per some of your examples?

([[:alpha:]]+)(\d+)