Identify Month and Year from multiple rows

[AshishAgarwal]

Hi Team,

I have to prepare one workflow in which I have to identify month and year in one coloumn having 3 lakh rows.

There are different date format in rows.

Example:

Para-dd-mm-yyyy

Comm/mm/yyyy

Alty-m-yyyy

Date_yyyymm

Top/Kom/mm/yy

Exam_Dar_yyyy-mm

Exam_Roc_yyyy/mm

Exam_Ash/m/yyyy

ABC_XYZ_mmyyyy

Ashish/XYZ/mm/dd/yyyy

Ashish_ABC_mm

Ashish_Vijay_dd-mm

one way I thought of doing it by applying filter but then i would be required to apply multiple filters.

Is there any tool which can help to extract month and year only from rows

Regard,

Ashish

[FrederikE]

Hey @AshishAgarwal,

The Go-To Tool for this would be RegEx - but you will need to write a few expressions to catch all of these variants. 

Regex is a language used to extract certain data strings. But you probably need to put some work into learning it, since it's not self-explanatory. 

[Felipe_Ribeir0]

Hi @AshishAgarwal 

You gonna need to extract this information using regex formulas to match every possible pattern of date.

I suggest you to use this site to test and learn regex101: build, test, and debug regex

This piece of code extract the bellow pattern for example:

\d{2}\-\d{4}|\d{2}\/\d{4}

2 digits - 4 digits OR 2 digits / 4 digits

Here is a sample workflow with half of the rows solved for you to start with: