Extracting Partial FileName within []

[zekharya]

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!

[binuacs · Accepted solution]

@zekharya One way of doing this

REGEX_Replace([File NAme], '.*\[(.+)\].*', '$1')

[grazitti_sapna · Accepted solution]

@zekharya Another way of doing it if you want both outputs in different columns.

[zekharya]

Thank you @binuacs and @grazitti_sapna!