By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| YourColumn | bad_chars | Cleaned |
|---|---|---|
| abc12jsgfedj435afd | abcjsgfedjafd | 12435 |
| 1234 | 1234 | |
| 1234 | 1234 | |
| ABC1 | ABC | 1 |
| 1ABC | ABC | 1 |
| abc | abc |
| YourColumn | bad_chars | Cleaned |
|---|---|---|
| abc12jsgfedj435afd | abcjsgfedjafd | 12435 |
| 1234 | 1234 | |
| 1234 | 1234 | |
| ABC1 | ABC | 1 |
| 1ABC | ABC | 1 |
| abc | abc |