I want to split values based on multiple values like ! and %, operators, but STRING_SPLIT only allows 1-character delimiters.
My string is like this:
99001316 - ABCD 250 ML!%! 
I want to split values based on multiple values like ! and %, operators, but STRING_SPLIT only allows 1-character delimiters.
My string is like this:
99001316 - ABCD 250 ML!%!