Dear Support,
I wanted to use the conversion function to produce output in UK number formats, My input file contains European and UK format number system.
With the help of CloverDX support (Thank you) I have managed to work out the graph (unable to attach). It works fine for digit of 4 i.e. "12.23" (UK) or "12,23" (European) but it is not giving me output for larger numbers for example:
12,36 (European)
12.36 (UK)
1.213,45 (European)
1,213.45 (UK)
1.213.456,897 (European)
1,213,456.897 (UK)
I need all the above to product output in UK format.
Expression, I have used in the Map component 
is below:
//#CTL2
function integer transform() {
$out.0.after =iif(isDecimal($in.0.before)==true, str2decimal($in.0.before,"##,##", "en.GB"),str2decimal($in.0.before,"##.##","cs.CZ"));
return ALL;
}
Also, any date formats either input file contains US or UK both to UK formats as well.
Kind regards,
Asim
Please sign in to leave a comment.
Comments 0