SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

remove all punctuation - only letters and numbers

2890953Mar 4 2015 — edited Mar 4 2015

Hello,

how can I remove all punctuation. Thus, only those letters and numbers stand?

Example:

String before: "§%67778/%&45$$---§§$5FCGZZ-GZGUU(=&/+%/&%E$Dfcfhzb+++zvb

String after: 67778455fcgzzgzguuedfcfhzbzvb

My Code until now:

REPLACE(

TRANSLATE(

LOWER(TRIM(BEZEICHNUNG))

, '@-.', '@' )

, ' ', '')

, '', '')

, '-', '')

, CHR(10), '')

thanks for your help in advance

This post has been answered by fac586 on Mar 4 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2015

Added on Mar 4 2015

6 comments

2,360 views