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
Last activity: May 27, 2024, 05:44 PM