Forum Discussion

calithl450's avatar
calithl450
Copper Contributor
Jul 27, 2023

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！

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jul 27, 2023

    calithl450 

    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.

Resources