Hi All,
I have been struggling to find a solution where I can create a new row if a specific Character '/' is detected from the right(ideally), and then the new row has the data after the character:
The data in a column is as followed:
Oti22:35/id006/pi000/OP
Oti22:43/id006/pi000/CL
Nti04:12/ri1/RP
Nti08:30/id4/ri1/OP
NRP
Nid1/OP
Nid1/CL
NRP
Nid1/OP
Nid4/CL
Example of what I looking for below:
Oti22:35/id006
/pi000
/OP
Oti22:43/id006
/pi000
/CL
Nti04:12/ri1
/RP
Nti08:30/id4
/ri1
/OP
NRP
Nid1/OP
Nid1/CL
NRP
Nid1/OP
Nid4/CL
Any thing like above would be great.
Bookmarks