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

[binuacs]

@sriniprad08 

Trim(REGEX_Replace([Sit], '(.*)(\s)', "$2"))

[atcodedog05]

Hi @sriniprad08 

My take on this

Formula:

REGEX_Replace([Sit], "[^\s]+\s[^\s]+\s(.+)", "$1")

Workflow:

Hope this helps : )

[sriniprad08]

Hi @binuacs ,

Thank you so much. I need help with the below please . Can you please let me know how to go about it?

Cheers,

Sr

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much. 🙂 I need one more help I have attached the file. Can you please help me with that?

Cheers,

Sr

[atcodedog05]

Hi @sriniprad08 

Give this a try.

Hope this helps : )

[binuacs]

@sriniprad08 

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help. Is it possible to remove the bracket from the below output after extracting it. Like below please only with KERATE and not bracket in a separate column with all other values.

Thanks

Sr

[atcodedog05]

Hi @sriniprad08 

Please find the updated workflow.

Formula:

REGEX_Replace([Sit], "[^\s]+\s[^\s]+\s\(?([^)]+)\)?", "$1")

Hope this helps : )

[OllieClarke]

Hi @sriniprad08 

Lots of solutions already, but here's how I would do this:

Parsing 

.* (.+)

which will output everything after the final space into a new column

Hope that helps,

Ollie