Hi guys i need help or any hint for the below scenario,
i have a column in a table with delimited string like below with varying lengths
ABC|| FCD||BCD||CDF
DGGFD||ABVFD||GFSDH||BCDDG
i need the results string values in column to be shown as below , with ascending order
ABC||BCD||CDF || FCD
ABVFD||BCDDG||DGGFD||GFSDH
is there any custom function or code that anybody has in handy, i have already explored the split function , but split function can only deconcatenate the string values i want them in concatenated
format in ascending order.
let me know if my description is not clear, thanks in advance