Hi all,
I would like to extract partial filenames within [] brackets.
Filename - "Real estates [Data centre] [SGD, RM].xlsx"
For example, I would like the output column to be "Data centre" or "SGD, RM" where required.
What will the RegEx expression be?
I was able to extract "Real estates" using (\<\w+\s+\w+\>).
Thank you in advance!
Solved! Go to Solution.
Thank you @binuacs and @grazitti_sapna!