Mapping Payment Format - Replace decimal with comma

Aug 8, 2025 12:04AM

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 -

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 -

Mapping Payment Format - Replace decimal with comma

Howdy, Stranger!