How to filter or get only date numeric values from the string

[Parthiban.VD (Parthiban Vaithilingam)]

Hello guys,

I am facing one issue, I have a string “str_inputdate = 01/14/2020 IBM CORPORATION”, from the particular string i need to filter date only “01/14/2020” & I need to remove the text “IBM CORPORATION”

so please suggest, what regex can I use to remove the text or characters from the string.

Thanks, Advance

[AshwinS2 (Ashwin S)]

@Parthiban.VD

01/14/2020 IBM CORPORATION

Hi @Parthiban.VD

you can use matches activity based on regex expression as \d

and retrieve the string

Thanks
Ashwin S

[Pradeep_Shiv]

@Parthiban.VD

01/14/2020 IBM CORPORATION

hey @Parthiban.VD use this expression to get any date format from above string \d{1,2}.\d{1,2}.\d{1,4}
cheers @Parthiban.VD

Chech this sample regex101: build, test, and debug regex

[Parthiban.VD (Parthiban Vaithilingam)]

@Pradeep_Shiv

\d{1,2}.\d{1,2}.\d{1,4}

Hi,

Thanks for reply @Pradeep_Shiv , it’s working

[Parthiban.VD (Parthiban Vaithilingam)]

Hi,

Thanks for your reply @AshwinS2

[Pradeep_Shiv]

great mark it as a solution and close this thread!