Data Port Fixed length output decimals

John

I’m building an output oriented Data Port for a Fixed Length output file.
I want to output a decimal field with 2 fixed decimals and a right alignment.
Nothing spectacular I think, but NAV370 disagrees with mee.
Any hints on this?

Torben_R.

try this

PADSTR('',13-STRLEN(FORMAT(Amount,0,'<Precision,2:2><Standard Format,0>')),' ') +
FORMAT(Amount,0,'<Precision,2:2><Standard Format,0>')

John

Tanks, it does the trick.
Is it a simple solution for a simple problem, Nuh!