susanna123
Technical User
Hello,
I use the left, mid and right function to parse this string but am not getting it accurate. This is the data from the field: can you help with formula?
Original: ABCDEFGHIJKLML - 12345678 - HelloWorld
The output should look like this without the word "Original" and the "-"
ABCDEFGHIJKLML
12345678
HelloWorld
I use the left, mid and right function to parse this string but am not getting it accurate. This is the data from the field: can you help with formula?
Original: ABCDEFGHIJKLML - 12345678 - HelloWorld
The output should look like this without the word "Original" and the "-"
ABCDEFGHIJKLML
12345678
HelloWorld