Split a column based on a text

Question

Hi,

I am trying to split a column based on "00000000" in a string using Reg Ex.

Input:

Field 1aeccr53424,drgef3245300000000fanewors wedx253wdasdfkjre00000000wec244255v kerthwdk00000000ertogisnfslae

Output:

Field 1Field 2aeccr53424,drgef3245300000000fanewors  wedx253wdasdfkjre00000000wec244255v  kerthwdk00000000ertogisnfslae

Please help!

Thank you!!

ChrisTX · Accepted Answer

Use the RegEx tool with Output Method = Parse, with this Regular Expression:

.*0{8}(.*)

Chris