Logical help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Can any one help me in understanding this logic:

"LET vZahlenformat_EN = chr(39) & '#,##0.' & chr(39) & '& Repeat(' & chr(39) & '#' & chr(39) & ', $(vDezimalstellen))' "

Re: Logical help

alexandros17 — Fri, 14 Jul 2017 15:25:27 GMT

LET vZahlenformat_EN = chr(39) & '#,##0.' & chr(39) & '& Repeat(' & chr(39) & '#' & chr(39) & ', $(vDezimalstellen))' "

Is formatting decimal part of a number setting the number of decimal digits:

chr(39) is the value for the character '

the instruction Repeat, repeats a symbol more times.

so if you replace chr(39) with ' and remove the existings characters ' the string becomes:

'#,##0.' & Repeat('#',$(vDezimalstellen))

that is a concatenate (& symbol) between #,##0. and # repeated vDezimalstellen times