FDMEE DR CR split Jython function in a delimited file
edited Jun 6, 2016 2:29PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 4 commentsAnswered ✓
Hi,
We used this VB code for the DR CR split in a delimited file:
If IsNumeric(DW.Utilities.fParseString (strField, 5, 5, ",")) = "True" Then
EWG_AMT = DW.Utilities.fParseString (strField, 5, 5, ",")*"-1"
Else
EWG_AMT = DW.Utilities.fParseString (strField, 5, 4, ",")
End If
We are trying to to this in Jython:
def DRCR (strField, strRecord):
StrDR = seglist = strRecord.split(",")
return seglist[3].strip()
This only returns the first DR column, we need to retrieve the second CR column if DR is blank.
Any help would be greatly appreciated.
Thanks,
Eldo
Tagged:
0