Hi experts,
my scenario is proxy to FCC(field fixed lengths) , preTaxDeduction field lenght (10) output format is [-]9(6).
Mapping: -
i have done mapping like below format
my input field values like my fcc out put format like
4500.00- -004500.00
2500.00 2500000.00
(1) Current Pre-Tax Deduction – First record negative amount is formatted correctly, but second record’s amount is short by 1 digit… it should be 0000000.00 (7 digits to the left of decimal and 2 to the right). and
i am using udf (InvertPreSign) for "-" that sign
int b = a.lastIndexOf("-");
String result = a.substring(0,b);
result = "-"+result;
return result;
problem :--
second record’s amount is short by 1 digit… it should be 0000000.00
how can i achive this plz help me it's urgent requirement.
Thanks,
bhaskar