Extract "Strings" from a list of files names

[Terrymax]

Hi All

I have a list of files names, i want to extract strings in the 1st () and the last () of each file names below , then write to a new filed.  

The expected format like  : zz aaa ; zz bbb

List Name

MASTER (ZZ) DAT FILE v16(Final)_xxxx (aaa)_Jun'21.xlsx

MASTER (ZZ) DAT FILE v16_xxxx (bbb)_June'21.xlsx

MASTER (ZZ) DAT FILE v16 (2021) (cccc)_Jun'21.xlsx

MASTER (ZZ) DAT FILE v16 (2021) (dddddd)_Jun'21.xlsx

MASTER (YYY) DAT FILE v16 (2021)_xxxx (eeeeeei)_June'21.xlsx

MASTER (YYY) DAT FILE v16 (2021) _xxxx(ffffff)_June '21.xlsx

MASTER (YYY) DAT FILE v16 (2021) _xxxx(gggggg)_Jun '21.xlsx

MASTER (YYY) DAT FILE v16 (2021)_xxxx (hhhhhh)_17 Jun 2021.xlsx

[RolandSchubert · Accepted solution]

Hi @Terrymax ,

you can use FindString to find the first "(" and ")" and SubString to extract the string between the brackets, for the last brackets the same would be possible using ReserveString - you have to find the string between ")" and "(" and reverse the result. I've attached a sample workflow. Of course it is possible using RegEx as well.

Let me know if it works for you.

Best,

Roland

[Terrymax]

It works! Super! Thanks so much!