FiveTech Software tech support forums

Posted: **Fri Oct 09, 2015 11:14 am**

Hi Antonio,
I have a big problem to convert a character field n5 char(20,0) to a dezimal field betrag(N,12,2)
I get the characterfield with csv conversion from bank.
-23,58 field n5
or
+11.931,76 field n5
with the code
betrag = val(n5)
the result is
-23.00 and not -23.58 or -23,58
the problem is, that there are no decimals.
Please can you give me here some examples for conversion.
Thank you
Best regards Armin

Posted: **Fri Oct 09, 2015 11:48 am**

Code: Select all

  betrag = val(strtran(strtran(n5,".",""),",","." ))

Posted: **Fri Oct 09, 2015 2:19 pm**

Vielen lieben Dank.
Es funktioniert ausgezeichnet.
Bin auch Kärntner vom Gailtal Presseggersee.
Bin nächste Woche in Kärnten, darf ich Sie auf ein Dinner einladen?
arminthurner@gmx.at
www.i-pointpartner.net
+436801263158
Liebe Gruesse
Armin Thurner

FiveTech Software tech support forums

Character to convert in decimal

Character to convert in decimal

Re: Character to convert in decimal

Re: Character to convert in decimal