Parse Data From the Filename

[DataPirate26]

Hi, 

I need to Parse out the Month and Year (Date) and the Required Data from the given Sample data. Can anyone help me with this ?

[binuacs]

@DataPirate26 One way of doing this

[DataPirate26]

@binuacs Can you once Check the Desired Output I have shared ? I need the other field "Search as well". That needs to be populated dynamically. 

[binuacs · Accepted solution]

@DataPirate26 Updated the workflow

[DataPirate26]

@binuacs Thank you for the quick solution, worked fine.