FDMEE amount issue - disregarding comma (as decimal separator)
edited Feb 9, 2016 6:18AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 3 commentsAnswered
Hello
I have a strange problem with importing a file using FDMEE. The import script is supposed to strip the amount for all except numbers and decimal separator. The script is simple:
def SAPPRO_D1_Amount(strfield, strrec):
import re
return float(re.sub("[^0-9^\,]", "", strfield).replace(",","."))/1000
But when the amount is returned the decimal separator is ignored, hence for example the amount: "829 441,46" is returned as 82,944.146 (it should have been 829.44146).
Any suggestions? Anybody experiencing the same issue?
To make it more strange I have performed the same script populating DESC1 column - and this works fine
def test(strfield, strrec):
Tagged:
0