RegEx

rajputakansha

Hello everyone,

I am trying to use RegEx to extract month(10,11,12) from file names. The file names are in the below format-

10 October 2022.xlsx

11 November 2022.xlsx

12 December 2022.xlsx

I need to extract month from the file path string, which looks like this-

\Shared\Data\12 December 2022.xlsx|`Sheet1$

Is there a simple way to achieve it?

Thanks in advance!

MarqueeCrew

@rajputakansha ,

If the data is as you describe, then I'd first use

FileGetFileName(FullPath): Returns the name portion of the path, without the

That gives you 12 December 2022

Then use:

DateTimeParse([datafromabove],"%d %B %Y)

see:  https://help.alteryx.com/20223/designer/datetime-functions

That gives you:

2022-12-12

Things should be doable now.

Cheers,

Mark