Converting dot(.) to comma(,) in a Crytal report

[Phyl1]

HI all,

How can i replace "." to "," ?????

Problem:
input of 10.0000 gives in the formula below 100000 as result. but this should be 10.
I replaced the "." into "," in the orginal file and that gave the desired answer of 10.
10,0000 should be 100000.

We don't want to replace the orginal files. what can i do?
FYI: I'm using crystal report just for 2 days.

NumberVar nLen;
StringVar sNum;
sNum := ToText({INVITEM_CSV.QUANTITY},4,",","."
nLen := Length(sNum);
If Right( sNum, 1) = "0" Then
nLen := nLen -1;
If Right( sNum, 2) = "00" Then
nLen := nLen -1;
If Right( sNum, 3) = "000" Then
nLen := nLen -1;
If Right( sNum, 4) = "0000" Then
nLen := nLen -2;
Left(sNum,nLen);

We use a csv-file as input.

Thnx in advance.
Phyl1

 

[minditx]

commonly i m using this method like your situation.right click at report field then select format editor. at tab order select number. u can select what format u want it.

but for case csv-file i dont have any idea.

good luck

 

[dgillz]

Are you trying to display currency in a European way such as 1.000,00 instead of 1,000.00?

If so this is a format option, just change the thouands separator and decimal point.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Reebo99]

Try creating a formula like :

ToText({INVITEM_CSV.QUANTITY},0,"&quot

Let me knwo how you get on....

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)