Hi All,
I am working on an upgrade from 11.1.1.3 to FDMEE 11.1.2.3. Please advise on the below.
I have a data file that is 14 columns long and the import format concatenates columns 4 + 6+ 14. In FDM 11.1.1.3 there was an import script that used the following logic:
Dim strICP
If strField = "" Then
BlankICP= "1500"
Else
BlankICP= strField
End If
When I try to use the same logic in Jython instead of vb script below Jython does not interpret the empty last column as a null and does not replace the null with the correct value which interferes with my Like maps. This logic works with other import scripts as long as it is added to a column of the concatenated string that is not the end of the file. Please note there is no space in column 14 when it is blank.
File Example:
2014|1|1500_01|027||51510||Trading|5000||USD|Segments|Trading|
2014|1|1505_02|037||51510||Trading|750||GBP|Segments|Trading|Full
def BlankICP(strfield, strrec):
if strfield == "":
return "Null"
else:
return "NotNull"
Validates in FDMEE to:
02751510
03751510NotNull