Forum Discussion
calithl450
Jul 27, 2023Copper Contributor
sql server
Hello experts, I would like to ask a question: Is there multiple special character truncation in a string? How to use oracle SQL to intercept multiple special characters in a string? Make them correspond to the corresponding column names? @ -> No.2, # ->No.3, $->No.4
Thank you very much for any help!
- olafhelperBronze Contributor
Is there multiple special character truncation in a string?No, there isn't such a function, even because per se there is no definion of "special characters". For example the dollar sign $ is quite common in finace secor.
You have to implement it on your own.