Data splitting help

[SCK]

Hi all, need help in splitting the data i have before as input and output:- Please help

Input:

02 00 WARRANTY/CARS  I84388001

02 00 WARRANTY-43050 I84454001

02 00 712253 I84586001

02 00 4551235398 I79304001

14 00 I0957 45512045 OA20191119001 C001

02 00 4551194900 H87 OA20200319001 C001 03/19/20

02 00 R&D CYLINDERS  I84449001

02 00 WARRANTY-43050 I84454001

02 00 WARRANTY & Cycle-43050 I84454003

Output:

02	00	WARRANTY/CARS	I84388001
02	00	WARRANTY-43050	I84454001
02	00	712253	I84586001
02	00	4551235398	I79304001
14	00	I0957 45512045	OA20191119001	C001
02	00	4551194900 H87	OA20200319001	C001	3/19/2020
02	00	R&D CYLINDERS	I84449001
02	00	WARRANTY-43050	I84454001
02	00	WARRANTY & Cycle-43050	I84454003

[PhilipMannering]

Hi @SCK 

Something like this might help,

The regex works for these specific cases. You might need to edit if the data changes considerably for other records.