FDM FDMEE Jython Import Script Error - excel .csv tab delimited
Thanks in Advance for looking/sharing - your consideration is certainly appreciated.
Can anyone provide a suggestion as to how best fix this failure?
I need a simple script to look at the last character of the 2nd column (Account) and determine if it is an ' @ ' symbol.
If yes, then multiply the value in the 6th column by -100 and return the record with the calculation performed.
Otherwise, return the record without the calculation.
(( Ideally, any Negative Value in END-BAL (column 6) Less than 0 and Greater Than -1 would return a Positive Whole Number e.g. -.17 would return 17 ))