Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am load a csv, but some field like IMPORTE1 doing num function does not transform in num
attached a qvw , the field IMPORTE1 is a text but in the load i am converting to num
what could be?
Thank you
Fernando
Hi Fernando,
Num(Num#(@13, '#,##0.00' ,'.',','), '#.##0,00') as importe1
the decimal separator can't be set with the format string, it has to be defined with a separate parameter in the num#() and num() functions if different from the default setting (like in your case: SET DecimalSep=',';)
hope this helps
regards
Marco
Trata de eliminar, por si los hay caracteres diferentes de los números con:
Num(Keepchar (importe1, '1234567890.,')) as importe
Hi Fernando,
Num(Num#(@13, '#,##0.00' ,'.',','), '#.##0,00') as importe1
the decimal separator can't be set with the format string, it has to be defined with a separate parameter in the num#() and num() functions if different from the default setting (like in your case: SET DecimalSep=',';)
hope this helps
regards
Marco
you´re mixing decimal separators
Your data uses '.' as decimal separator
You app uses ',' as decimal separador
SET ThousandSep=',';
SET DecimalSep='.';
at beginning of your code should solve this
OR use
purgechar(@13, '.,' )/100 AS importe1,