I have a field of currency values in an attribute table. As an example, I'm attempting to replace £10,000.00 to 10000.00 so QGIS can run graduated styles on the new field. The following replaces the £ sign with a blank character.
replace( "field_name", '£', '')
I'm struggling to get rid of the comma in the same expression. I have tried:
replace( "field_name", '£', '') || replace( "field_name", ',', '')
but this returns 10,000.00£10000.00
The 'replace' expression doesn't seem to cater for more than one character to target as a replacement. Do I need to do this over 2 expressions?