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 ?

[binu_acs]

@DataPirate26 One way of doing this

[DataPirate26]

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

[binu_acs · Accepted solution]

@DataPirate26 Updated the workflow

[DataPirate26]

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