Regex - Extracting text from a column with spaces, brackets and -

[sriniprad08]

Hi Team,

Hope you are well. I need help. I have column and i need to extract the text from the column.

Please find attached the input and output.

Thanks,

Sr

[OllieClarke]

Sorry @sriniprad08 just seen your post about removing the brackets,

A couple of ways to do this, if it's just brackets then this formula will do the trick

ReplaceChar([Output],'()','')

Alternatively you can use a RegExReplace() to remove anything which isn't a letter, number, underscore or hyphen with this:

RegexReplace([output],'[^\w-]','')

Ollie

[atcodedog05]

Hi @sriniprad08 

To add to above another option to remove brackets is using Trim function like below.

Trim([Sit_1],"()")

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help 🙂 Can you please help me one more thing ? Please find attached the input and the output.

The only difference is the one marked in red should be there in the ouput. thanks again.

[atcodedog05]

Hi @sriniprad08 

Give this a try.

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you very much :). I will go through it and let you know. 

Cheers,

Sr