Identify Month and Year from multiple rows

Question

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-yyyyComm/mm/yyyyAlty-m-yyyyDate_yyyymmTop/Kom/mm/yyExam_Dar_yyyy-mmExam_Roc_yyyy/mmExam_Ash/m/yyyyABC_XYZ_mmyyyyAshish/XYZ/mm/dd/yyyyAshish_ABC_mmAshish_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

Felipe_Ribeir0 · Answer

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:

Identify Month and Year from multiple rows.yxmd

FrederikE · Answer

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.