I am trying to split a column from the source file. The column is either 6 character long or 13 character long. first 6 are account and the next 7 are CC. not all records contain CC, but all contain an account.
I am using two import scripts to split the column. These seem very simple. I have tested them in IDLE and they both work exactly as expected. However, when I try to import data using FDMEE, I get an error. These scripts are very simple, and they work fine in Python IDE. I am pulling my hair out at this point trying to figure out what is not working. These are the only import scripts I am using. The rest of the fields are straight import. The scripts are below:
To get account:
def Get_Account(strField, strRecord):
return str(strField)[:6]
To get the CC if it exists:
def Get_CC(strField, strRecord):
if(len(str(strField))>6):
return str(strField)[-7:]
else:
return "NoString"
I get the following error in the process log:
2020-07-19 14:18:43,929 DEBUG [AIF]: EPMFDM-140274:Message - Error Evaluating scriptnullorg.python.core.PyException.fillInStackTrace(PyException.java:70)
java.lang.Throwable.<init>(Throwable.java:181)
java.lang.Exception.<init>(Exception.java:29)
java.lang.RuntimeException.<init>(RuntimeException.java:32)
org.python.core.PyException.<init>(PyException.java:46)
org.python.core.PyException.<init>(PyException.java:43)
org.python.core.PyException.<init>(PyException.java:61)
org.python.core.Py.NameError(Py.java:220)
org.python.core.PyFrame.getname(PyFrame.java:276)