Split a column based on a text

[Arunima_S]

Hi,

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

Input:

Field 1

aeccr53424,drgef3245300000000fanewors

wedx253wdasdfkjre00000000wec244255v

kerthwdk00000000ertogisnfslae

Output:

Field 1	Field 2
aeccr53424,drgef3245300000000	fanewors
wedx253wdasdfkjre00000000	wec244255v
kerthwdk00000000	ertogisnfslae

Please help!

Thank you!!

[ChrisTX · Accepted solution]

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

.*0{8}(.*)

 

Chris

[grazitti_sapna]

Hi @Arunima_S , try this.

Thanks.