Jython FDMEE Scripting Replace Euro Decimal with USD Decimal
edited Jun 6, 2016 2:42PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered ✓
I was attempting to test a Python script (technically its Jython) we need to create in the import script in FDMEE that will convert the euro decimal (,) to the us decimal (.). Also, the Fill=EurotoUS cannot be used in this situation. The following script is close to what I need, however it seems to not replace the decimal and only removes it all together, ie: 1234,55 to 123455. When it should be 1234,55 to 1234.55.
def ReplaceCommas(strField,strRecord):
strField.replace(',','.')
Realistically, I'm looking for more of an if else script like the following:
def ReplaceCommas(strField,strRecord):
if "," in strField:
0