Sample Header Ad - 728x90

Remove spaces and replace characters with regexp_replace()

0 votes
3 answers
1415 views
I wish to ... 1. ... remove spaces 2. ... delete apostrophes 3. ... replace 'é' and 'è' with 'e' I use the function regexp_replace(). For the moment, I can delete the spaces but poorly. Indeed, when the attribute contains several spaces only one is deleted. I can't process *1.*, *2.*, and *3.* at the same time. Is this possible? Below is a link to my code: https://dbfiddle.uk/22ODtpNS
Asked by fcka (125 rep)
May 25, 2024, 07:51 PM
Last activity: May 27, 2024, 05:44 PM