topic Re: convert text to number in App Development

convert text to number

Wouter_Denckens — Fri, 01 Mar 2019 11:04:07 GMT

Hi All,

I've been searching the forum for a specific problem … converting tekst to number. My problem is the tekst has leading spaces and the number found has to be converted from American notation to European notation.

Ive tried several things, but this is what still results partly:

num#(price, '#.##0,00', '.', ',')

The problem I have is that all numbers up to 999.99 are converted corectly, any number above goes wrong and stays tekst. Can anyone help me with this please?

Thanks in advance!

Re: convert text to number

el_aprendiz111 — Fri, 01 Mar 2019 11:50:40 GMT

Would you be able to share a sample?

Re: convert text to number

NhanNguyen — Fri, 01 Mar 2019 12:01:17 GMT

Try num#(price, '#,###.#0', '.', ',')

Re: convert text to number

Wouter_Denckens — Fri, 01 Mar 2019 12:43:01 GMT

Thanks Nhan! Why was my script wrong? I assumed the second part of the num# function is the way it should return the data?