I need to write a sql script to split a string in two or more parts.
I have a string: "tag: key1, key2, key3"
I would like to use the ":" as a seperator and thus end up with two strings:
"tag" and "key1, key2, key3"
Is this possible?
I was thinking of using a function to find and return the position of the ":" and then using substr to split the string, but I dont know of any functions that return the position of a character.
Any help is much appreciated, thanks.