Hi,
I am using FDMEE and have been trying unsuccessfully to remove the currency symbol from the amount column in the source data file.
Following are some of the options I tried but it just does not work -
1. def ReplaceCurr(strField,strRecord):
strField = strField.replace("£","")
return strField
2. def ReplaceCurr(strField,strRecord):
return strField.replace(strField,"£","")
3. def ReplaceCurr(strField,strRecord):
return string.replace(strField,"£","")
4. def ReplaceCurr(strField,strRecord):
return strField.split("£").join("")
5. def ReplaceCurr(strField,strRecord):
#newStrRecord = strRecord.replace("£","")
return newStrRecord.split(",")[5]
This one sort of validates but we have commas in the amount field so this option splits the amount and loads the incorrect amount value.
A sample record is as below -
Reporting Store,name,Account Number,description,Period 01 2016,Period 02 2016,Period 03 2016,Period 04 2016,Period 05 2016,Period 06 2016,Period 07 2016,Period 08 2016,Period 09 2016,Period 10 2016,Period 11 2016,Period 12 2016
1,Store 1,10000,GrossSales,"1,839.10","£450.50","67.90","120.45","90,230.23","34,890.44","12,450.99","32,000.67","230.90","7,500.12","230.21","120.90"
We are using FDMEE 11.1.2.4 and this script is an import script attached to the amount field. The file is a multi-period file.
I have seen other blogs and tried almost every option but nothing seems to work.
Any help is appreciated.
Many Thanks.