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?