Skip to Content
0
Former Member
Nov 09, 2012 at 09:32 AM

my scenario is proxy to FCC , preTaxDeduction field output format is [-]9(6)

430 Views

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

Attachments

mappingpretax.JPG (35.5 kB)