Mapping Payment Format - Replace decimal with comma
Summary:
Mapping Payment Format - Replace decimal point with comma
Content (please ensure you mask any confidential information):
EText RTF Template - Fixed position template
I need to replace the decimal point with comma. The length of the field should be 17 with addition of zeros with LPAD.
Expected Results -
123 should be 00000000000123,00
123.45 should be 00000000000123,45
123.4544 should be 00000000000123,45
My configuration -
<Position> <Length> <Format> <Pad> <Data>
15 17 Number, ###.00 L, '0' TotalPaymentAmount/Value
Sample XML -
<InstructionTotals>
<PaymentCount>1</PaymentCount>
<TotalPaymentAmount>
<Value>100567</Value>
<Currency>
<Code>USD</Code>
</Currency>
</TotalPaymentAmount>
</InstructionTotals>
With no formatting for comma I get result from above as 00000000100567.00
For comma formatting I added this at Format Setup at command tables -