By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (CASEWHENREGEXP_LIKE(COLUMN1,'[0-9]*[.,]+[0-9]+')THENREPLACE(COLUMN1,',','.')ELSE'0'END) |
|---|
| 0 |
| 0 |
| 1.30 |
| 1.30 |
| 0 |
| 0 |
| 0 |
| 0 |
| (CASEWHENREGEXP_LIKE(COLUMN1,'[0-9]*[.,]+[0-9]+')THENREPLACE(COLUMN1,',','.')ELSE'0'END) |
|---|
| 0 |
| 0 |
| 1.30 |
| 1.30 |
| 0 |
| 0 |
| 0 |
| 0 |