I have a string such as this: a|b^c|d|e^f|g
and I want to maintain the pipe delimiting, but remove the carrot sub-delimiting, only retaining the first value of that sub-delimiter.
The output result would be: a|b|d|e|g
Is there a way I can do this with a simple SQL function?
Aucun commentaire:
Enregistrer un commentaire