Forum Discussion

ARP331AHS269's avatar
ARP331AHS269
Frequent Visitor
3 years ago

Need help with splitting data using delimiters

Hello,

 

I have data in the format

 

INCWKN
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 

 

INCDate-TimeAgent NameNotes
INC12345604-Mar-2023 11:58:32Firstname Lastname1Monitoring the server.
INC12345606-Mar-2023 07:49:24Firstname Lastname2Promoted to a major incident. Waiting for Vendor.

 

 

Please advise on how to achieve this 

 

Thanks!

Need Help

2 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    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's avatar
      ARP331AHS269
      Frequent Visitor
      3 years ago

      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