Splicing Detailed Cells of Data

[kubikbr]

We have a dataset with a very long description column. How do I best go about breaking this up into usable chunks?

Examples to extract:

Cust ID: and the following information

Comp Name: and the following information

Comp ID: and the following information

Cust Name:

Date:

Time:

 etc.

Thanks

[binuacs · Accepted solution]

@kubikbr you can split the data using regex tool