Forum Discussion
Need help with splitting data using delimiters
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...
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 !
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