By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_REPLACE('DATE,LOCATION,DATA1,DATA2,DATA3,$787-$456-$875,6.08-15.52,30.46,5,5,NAME,LASTNAME,42.71',',(([^,]*,){5}[^,]*)$','-\1') |
|---|
| Date,Location,Data1,Data2,Data3,$787 - $456 - $875,6.08 - 15.52 - 30.46,5,5,Name,LastName,42.71 |