Extract from File Name

[Mauricio_1995]

hi 

i need to extract the month and year from the FileName as shown below.

C:\Users\HW987CF\OneDrive - EY\Desktop\Learning-EY\Training-Alteryx Bootcamp\Sesion 1_Ejercicio\Compañia 1.xlsx|||Abril 2021

any ideas?

Thanks

[ChrisTX · Accepted solution]

Try this in a Formula tool:

Substring([Full Path],FindString([Full Path], "|||")+3)

[NMangera · Accepted solution]

@Mauricio_1995,

here is a screenshot and workflow. Just replace the text input tool with your file

[binuacs · Accepted solution]

@Mauricio_1995 Another method