FDMEE Jython commas to decimals for Amount Column
edited Feb 20, 2016 4:02AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 7 commentsAnswered
I'm having an issue in 11.1.2.3.700 where I am trying to create a jython script that would allow the loading of a flat file with either a decimal or a comma for the dollar-cents separator.
I cannot use the Import Format "Fill=Euro to US" since a user might submit a file in either format. I tried to create a jython script:
def ReplaceCommas(strField, strRecord):
Rep=strField.replace(',','.')
return Rep
This however seems to only remove the comma and not replace it with a decimal. The script above would load "32,338,535", when "323,385.35" is supposed to be loaded.
Tagged:
1