Import script giving extra columns in target data
Hi All,
I converted Vb script to Jython but its giving extra C00 columns. I don't understand why its giving extra columns. Please correct the Jython script.
Function EaglePC2(strField, strRecord)
VB Code:
If strField = "" then
PC = DW.Utilities.fparseString(StrRecord,15,11,";")
For i = 1 to 10-Len(PC)
PC="0" & PC
Next
EaglePC2 = "P" & PC
Else
For i = 1 to 10-Len(strField)
strField="0" & strField
Next
EaglePC2 = "C"& strField
End If
Converted Jython Code:
def EaglePC2(strfield,strrecord):
if strrecord.split(';')[9]=='':
return "P"+str(0)*(10-len(strrecord.split(';')[10]))+strrecord.split(';')[10]
elif strrecord.split(';')[9].isdigit():
return "C"+str(0)*(10-len(strrecord.split(';')[9]))+strrecord.split(';')[9]