Reg Ex use case

Question

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.

InputOutputBDWS BM43:BBM43:BELTM EM01 EM01ESPK ER09-2ER09-2BAUL BL39:BBL39:BROOT RO24:DRO24:D

atcodedog05 · Accepted Answer

Hi @ahsansalik

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

Hope this helps 🙂

apathetichell · Accepted Answer

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

Jonathan-Sherman · Accepted Answer

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

mceleavey · Accepted Answer

Hi @ahsansalik ,

I thought I would have a go too 😄

^.*?\s

M.