aplicar separador de miles a un numero - Apply thousands of thousands to a number - Forum - VisualNEO. Cross-platform App Development Tool for Windows

#1 · May 12, 2022, 8:00 am

ESPAÑOL

Hola! hay algun plug o funcion que permita aplicar separador de miles a un numero...

por ejemplo tengo una variable que me trae un numero 2900 hay alguna forma de transformar este numero a 2.900? (separando con punto no coma)

Gracias desde ya

ENGLISH

Hello! There is some plug or function that allows you to apply thousands of thousands to a number ...

For example, I have a variable that brings me a 2900 number, is there any way to transform this number of 2.900? (separating with point does not eat)

thanks!

#2 · May 12, 2022, 8:27 am

take a look here https://webhelp.visualneo.com/VariableFilters.html

#3 · May 12, 2022, 9:18 am

@roccocogliano

Bad this is for visualneo WEB and i need for neobook or visualneo WIN

Thanks

#4 · May 12, 2022, 9:25 am

ok, I'm sorry. I hadn't read carefully.

regards
Rocco

#5 · May 12, 2022, 5:12 pm

@joferar333

There might be a third party plugin for this (I faintly recall this type of enquiry during the NeoBook days.

However, it is possible to accomplish this without a plugin (i.e. using a Subroutine or a Call'able external Function).

Can you clarify your requirement ?

a) does your number/text have decimals ? ... if so, is the decimal separator a dot or a comma ?

b) what is the maximum number you need to handle ? ... 99 million, 999 million or more ?

#6 · May 12, 2022, 5:32 pm

The good old NeoFormatNum plugin...

Greetings from Buenos Aires,

David de Argentina

Uploaded files:

You need to login to have access to uploads.

#7 · May 12, 2022, 11:23 pm

Hola @davideargentina

muchisimas gracias...

Lo he probado pero solo me transforma una... en mi caso en una pagina tengo 3 numeros por convertir y solo me lo hace con el primero el resto no...

Setvar "[number]" "[total1]"
SetVar "[length]" "8"
Setvar "[decimals]" "0"
Setvar "[milliards]" "3"
Setvar "[fill_char]" "$"

AE_FormatNum "[number]|[length]|[decimals]|[milliards]|[fill_char]"
Setvar "[totalbruto]" "[ae_resultado]"


Setvar "[number]" "[total_deuda]"
SetVar "[length]" "8"
Setvar "[decimals]" "0"
Setvar "[milliards]" "3"
Setvar "[fill_char]" "$"

AE_FormatNum "[number]|[length]|[decimals]|[milliards]|[fill_char]"
Setvar "[totalgasto]" "[ae_resultado]"

Setvar "[number]" "[real]"
SetVar "[length]" "8"
Setvar "[decimals]" "0"
Setvar "[milliards]" "3"
Setvar "[fill_char]" "$"

AE_FormatNum "[number]|[length]|[decimals]|[milliards]|[fill_char]"
Setvar "[bruto]" "[ae_resultado]"

Saludos

#8 · May 13, 2022, 12:13 am

La variable "[length]" tiene que incluir digitos adicionales para incorporar el caracter separador de miles ("." o ",")

En el caso de agregar decimales, hay que agregar a la variable "[length]" tantos caracteres como decimales se agregue, mas un caracter adicional para la coma o el punto decimal.

En tu ejemplo, prueba con agregar a variable "[length]" = 9 en vez de 8

Saludos,

David de Argentina