I have a few tab delimited source files with those €, £, US$ in front of the value in the amount field. I've been doing Edit/Replace for a while but there is surely a way to discard or remove those at the import. I've tried a few thing in terms of import script. I only want to know what would be the easiest way to get only the numeric value in the amount field?
Many thanks! Patrick