Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

numbers conversion

Hi,

I'm reading data from XML. Some of them denote prices. There is a problem that some prices are for example 1562,0000. There is more zeros than is normal :-) I'm sending this data out and other application shows bad prices.

Do you know how to process this data to display correctly on the other side?

thanks
0
xRalf
Asked:
xRalf
2 Solutions
 
angus_young_acdcCommented:
The following site should help you format them correctly:
http://blog.stevex.net/index.php/string-formatting-in-csharp/
0
 
xRalfAuthor Commented:
Thanks for link, which methods would you use for formatting the string to remove the comma and redundant zeros?
0
 
Joni KettunenSenior Software EngineerCommented:
Depending on your culture and what results you want, here is one example. It is based on same information angus_young_acdc has shown.

First given number is formatted as currency string. Note that currency is shown as specified in current culture (System.Threading.Thread.CurrentThread.CurrentCulture.NumberFormat).

Of course you might want to show result as a generic number. You can define how many digits is shown jut by adding number after format: n0, n1, n2, n3... to show specified number of digits. This is not usually mentioned in documentation.
decimal result = Convert.ToDecimal("1562,0000");
 
// Currency string -> $1,562.00 or 1 562,00 ¬
String.Format("{0:c}", result);
// Number string -> 1,562.00
String.Format("{0:n}", result);
// Number string -> 1,562
String.Format("{0:n0}", result);
// Number string -> 1,562.000
String.Format("{0:n3}", result);

Open in new window

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now