Reg Ex use case

[ahsansalik]

Hi I need help with the following, In the table i have input column and i have a pattern that all the values in the column have 4 letters than space and then the rest of alphanumeric pattern i want to use regex function to remove first 4 letters and space and have the remaining alpha numeric value in an output column. 

Input	Output
BDWS BM43:B	BM43:B
ELTM EM01	EM01
ESPK ER09-2	ER09-2
BAUL BL39:B	BL39:B
ROOT RO24:D	RO24:D

[atcodedog05 · Accepted solution]

Hi @ahsansalik 

Here is how you can do it. Replacing first 4 character & space to blank "" 

Hope this helps 🙂

[apathetichell · Accepted solution]

 

regex_replace([input],"\w{4}\s(.*)","$1") should work. workflow to follow.

[Jonathan-Sherman · Accepted solution]

Hi @ahsansalik,

You could use the regex_replace() function to remove the characters, but the simpler approach might be just to use a text to column tool with a space as the delimiter? Both will yield the same result!

I've attached my workflow for you to download if needed.

Kind regards,

Jonathan

[ahsansalik]

Thanks Mate worked like a charm 🙂

[ahsansalik]

Loved the approach to get to the solution thank you so much i tried this it also worked thanks a lot

[mceleavey · Accepted solution]

Hi @ahsansalik ,

I thought I would have a go too 😄

^.*?\s

M.

[ahsansalik]

Loved the approach to get to the solution thank you so much i tried this it also worked thanks a lot

[ahsansalik]

Jonathan never thought of that way :S it was so obvious staring me in the face 🙂 Thanks