Need help with splitting data using delimiters

[ARP331AHS269]

Hello,

I have data in the format

INC	WKN
INC123456	04-Mar-2023 11:58:32 - Firstname Lastname1 (Work notes)Monitoring the server.06-Mar-2023 07:49:24 - Firstname Lastname2 (Work notes)Promoted to a major incident.Waiting for Vendor.

I'll have to split this data into 

INC	Date-Time	Agent Name	Notes
INC123456	04-Mar-2023 11:58:32	Firstname Lastname1	Monitoring the server.
INC123456	06-Mar-2023 07:49:24	Firstname Lastname2	Promoted to a major incident. Waiting for Vendor.

Please advise on how to achieve this 

Thanks!

[serpiva64]

Hi,

you get this

by:

-split cloumn by delimiter to rows

- split column by delimiter (notice that the delimiter used is " - " with a space before and one after)

and finally split by delimiter

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[ARP331AHS269]

@serpiva64  - Thank you for the quick response 

Usually, I'll have multiple statements within a single work notes 

I think "." cannot be used as demiliter to rows 

I have updated the sample table