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 !!

[davidskaife · Accepted solution]

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+)

[bubblyjai1982]

Thanks you David

year will be all future dates - should work

Thanks Again !!