in the SQL table there’s basically field stuffing going on and the string literal in the table column would be bananas apples pears apples bananas pears with a double backslash delimiting each. So I’m 100% certain the every delimited record read in from the table has a double backslash in the string as a delimiter between each word where a field has been stuffed with multiple values.
Thus, I’m reading in a column value from a SQL query, it needs to be deduped and sorted and written back with two backslashes, just the way it was retrieved from the table.
Various calls and their results:
