C# - C sharp - String to decimal, decimal point disappears!

[BA]

Hello,

I have a string with a price in: "$14.95"

I need to get it into a decimal.

So I regex 'd the string and dumped the $. Debug mon shows a clean string
"14.95"

Then I do a System.Convert. ToDecimal on the clean string and the output
becomes: 1495

What gives!? I've tried a variety of workarounds but nothing works. How
can I format it for 2 decimal places or perform the convert in a way I am
not aware of?

Thanks alot!

[Peter Mancini]

Show us the code. Copy it from your program. Might be a syntax issue.

[BA]

"Peter Mancini" <pe***********@ gmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Show us the code. Copy it from your program. Might be a syntax issue.

Thanks for the response, here is the code (cutout try catch for ease of
reading, other funciton just returns the decimal:

>>>>>>>>>>> code>>>>>>>>>>> >>>>>
public decimal Lookup(string ISBN)
{
string CleanPrice;
decimal decCleanPrice;

System.Diagnost ics.Trace.Write Line("AmazonWeb ServiceDLL:Amaz onLookupAdapter
ENTER");

//Create Instance of Proxy Class
SService as1 = new SService ();

SService.lookup = ISBN;

CleanPrice = as1.AsinSearchR equest(asin);

CleanPrice =
System.Text.Reg ularExpressions .Regex.Replace( pi.Details[0].OurPrice,Syste m.Text.RegularE xpressions.Rege x.Escape("$"),
"");
System.Diagnost ics.Trace.Write Line("price: " + CleanPrice);

decCleanPrice = ConvertStringDe cimal(CleanPric e.ToString());

System.Diagnost ics.Trace.Write Line(System.Con vert.ToString(d ecCleanPrice));
System.Diagnost ics.Trace.Write Line("EXIT");

return decCleanPrice;
}

internal decimal ConvertStringDe cimal(string stringVal)
{
decimal decimalVal;

try
{
decimalVal = System.Convert. ToDecimal(strin gVal);
System.Diagnost ics.Trace.Write Line("The string as a decimal is {0}.",
decimalVal.ToSt ring());
return decimalVal;

}
catch (System.Overflo wException)
{
System.Diagnost ics.Trace.Write Line("The conversion from string to
decimal overflowed.");
return 0;
}
catch (System.FormatE xception)
{
System.Diagnost ics.Trace.Write Line("The string is not formatted as a
decimal.");
return 0;
}
catch (System.Argumen tNullException)
{
System.Diagnost ics.Trace.Write Line("The string is null.");
return 0;
}
}

}
}
>>>>>>>> code>>>>>>>>>>> >>>>>

Thanks again

[SB]

I don't see the problem. The output I get is 14.95.

-sb

// Method simplified for clarity
internal decimal ConvertStringTo Decimal(string stringVal)
{
try
{
return System.Convert. ToDecimal(strin gVal.TrimStart( '$')); // remove
the "$", convert it to a decimal, then return it
}
catch (Exception ex)
{
System.Diagnost ics.Trace.Write Line(ex.Message );
}
return 0;
}

"BA" <bi************ ***@gmail.com> wrote in message
news:1109726232 .92275607742901 ff95e2563b42b19 7c8@teranews...

"Peter Mancini" <pe***********@ gmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Show us the code. Copy it from your program. Might be a syntax issue.

Thanks for the response, here is the code (cutout try catch for ease of
reading, other funciton just returns the decimal:

>>>>>>>>>>> >code>>>>>>>>>> >>>>>>
public decimal Lookup(string ISBN)
{
string CleanPrice;
decimal decCleanPrice;
System.Diagnost ics.Trace.Write Line("AmazonWeb ServiceDLL:Amaz onLookupAdapter
ENTER");

//Create Instance of Proxy Class
SService as1 = new SService ();

SService.lookup = ISBN;

CleanPrice = as1.AsinSearchR equest(asin);

CleanPrice =
System.Text.Reg ularExpressions .Regex.Replace( pi.Details[0].OurPrice,Syste m.Text.RegularE xpressions.Rege x.Escape("$"),
"");
System.Diagnost ics.Trace.Write Line("price: " + CleanPrice);

decCleanPrice = ConvertStringDe cimal(CleanPric e.ToString());
System.Diagnost ics.Trace.Write Line(System.Con vert.ToString(d ecCleanPrice));
System.Diagnost ics.Trace.Write Line("EXIT");

return decCleanPrice;
}

internal decimal ConvertStringDe cimal(string stringVal)
{
decimal decimalVal;

try
{
decimalVal = System.Convert. ToDecimal(strin gVal);
System.Diagnost ics.Trace.Write Line("The string as a decimal is {0}.",
decimalVal.ToSt ring());
return decimalVal;

}
catch (System.Overflo wException)
{
System.Diagnost ics.Trace.Write Line("The conversion from string to
decimal overflowed.");
return 0;
}
catch (System.FormatE xception)
{
System.Diagnost ics.Trace.Write Line("The string is not formatted as a
decimal.");
return 0;
}
catch (System.Argumen tNullException)
{
System.Diagnost ics.Trace.Write Line("The string is null.");
return 0;
}
}

}
}
>>>>>>>>> >code>>>>>>>>>> >>>>>>

Thanks again

[Ricky Lee]

Does your system use the . (dot) symbol as the decimal symbol? Some european
country use the comma (,) as decimal symbol, and dot (.) as the digit
grouping symbol. If you're in the latter case, the conversion will ignore
the dot and treat the "14.95" as "1495". You can solve this by using
specific CultureInfo object to specify the locale that you want to use.

Hope it helps.

-- Ricky Lee
=============== =============== ==============
^o^ "When all doors are closed, God will open a Windows" ^o^
=============== =============== ==============

"BA" <bi************ ***@gmail.com> wrote in message
news:1109726232 .92275607742901 ff95e2563b42b19 7c8@teranews...

"Peter Mancini" <pe***********@ gmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Show us the code. Copy it from your program. Might be a syntax issue.

Thanks for the response, here is the code (cutout try catch for ease of
reading, other funciton just returns the decimal:

>>>>>>>>>>>> code>>>>>>>>>>> >>>>>
public decimal Lookup(string ISBN)
{
string CleanPrice;
decimal decCleanPrice;

System.Diagnost ics.Trace.Write Line("AmazonWeb ServiceDLL:Amaz onLookupAdapter ENTER");

//Create Instance of Proxy Class
SService as1 = new SService ();

SService.lookup = ISBN;

CleanPrice = as1.AsinSearchR equest(asin);

CleanPrice =
System.Text.Reg ularExpressions .Regex.Replace( pi.Details[0].OurPrice,Syste m.T
ext.RegularExpr essions.Regex.E scape("$"), "");
System.Diagnost ics.Trace.Write Line("price: " + CleanPrice);

decCleanPrice = ConvertStringDe cimal(CleanPric e.ToString());

System.Diagnost ics.Trace.Write Line(System.Con vert.ToString(d ecCleanPrice)); System.Diagnost ics.Trace.Write Line("EXIT");

return decCleanPrice;
}

internal decimal ConvertStringDe cimal(string stringVal)
{
decimal decimalVal;

try
{
decimalVal = System.Convert. ToDecimal(strin gVal);
System.Diagnost ics.Trace.Write Line("The string as a decimal is {0}.",
decimalVal.ToSt ring());
return decimalVal;

}
catch (System.Overflo wException)
{
System.Diagnost ics.Trace.Write Line("The conversion from string to
decimal overflowed.");
return 0;
}
catch (System.FormatE xception)
{
System.Diagnost ics.Trace.Write Line("The string is not formatted as a
decimal.");
return 0;
}
catch (System.Argumen tNullException)
{
System.Diagnost ics.Trace.Write Line("The string is null.");
return 0;
}
}

}
}
>>>>>>>>>> code>>>>>>>>>>> >>>>>

Thanks again

[Dennis Myrén]

Try
System.Globaliz ation.NumberFor matInfo nfi = new
System.Globaliz ation.NumberFor matInfo();
nfi.NumberGroup Separator = ",";
string s = "14.95";
decimal value = decimal.Parse(s , nfi);
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"Ricky Lee" <de****@benzine .com> wrote in message
news:42******** *************** @news.wanadoo.n l...

Does your system use the . (dot) symbol as the decimal symbol? Some
european
country use the comma (,) as decimal symbol, and dot (.) as the digit
grouping symbol. If you're in the latter case, the conversion will ignore
the dot and treat the "14.95" as "1495". You can solve this by using
specific CultureInfo object to specify the locale that you want to use.

Hope it helps.

-- Ricky Lee
=============== =============== ==============
^o^ "When all doors are closed, God will open a Windows" ^o^
=============== =============== ==============

"BA" <bi************ ***@gmail.com> wrote in message
news:1109726232 .92275607742901 ff95e2563b42b19 7c8@teranews...

"Peter Mancini" <pe***********@ gmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

> Show us the code. Copy it from your program. Might be a syntax issue.
>

Thanks for the response, here is the code (cutout try catch for ease of
reading, other funciton just returns the decimal:

>>>>>>>>>>>>>>> code>>>>>>>>>>> >>>>>

public decimal Lookup(string ISBN)
{
string CleanPrice;
decimal decCleanPrice;

System.Diagnost ics.Trace.Write Line("AmazonWeb ServiceDLL:Amaz onLookupAdapter

ENTER");

//Create Instance of Proxy Class
SService as1 = new SService ();

SService.lookup = ISBN;

CleanPrice = as1.AsinSearchR equest(asin);

CleanPrice =

System.Text.Reg ularExpressions .Regex.Replace( pi.Details[0].OurPrice,Syste m.T
ext.RegularExpr essions.Regex.E scape("$"),

"");
System.Diagnost ics.Trace.Write Line("price: " + CleanPrice);

decCleanPrice = ConvertStringDe cimal(CleanPric e.ToString());

System.Diagnost ics.Trace.Write Line(System.Con vert.ToString(d ecCleanPrice));

System.Diagnost ics.Trace.Write Line("EXIT");

return decCleanPrice;
}

internal decimal ConvertStringDe cimal(string stringVal)
{
decimal decimalVal;

try
{
decimalVal = System.Convert. ToDecimal(strin gVal);
System.Diagnost ics.Trace.Write Line("The string as a decimal is {0}.",
decimalVal.ToSt ring());
return decimalVal;

}
catch (System.Overflo wException)
{
System.Diagnost ics.Trace.Write Line("The conversion from string to
decimal overflowed.");
return 0;
}
catch (System.FormatE xception)
{
System.Diagnost ics.Trace.Write Line("The string is not formatted as a
decimal.");
return 0;
}
catch (System.Argumen tNullException)
{
System.Diagnost ics.Trace.Write Line("The string is null.");
return 0;
}
}

}
}

>>>>>>>>>>>>>>> code>>>>>>>>>>> >>>>>

Thanks again

[cody]

What is the locale setting on your machine?

"BA" <bi************ ***@gmail.com> schrieb im Newsbeitrag
news:1109722721 .07f50f5ad92bcd bd43cb46789d944 1d5@teranews...

Hello,

I have a string with a price in: "$14.95"

I need to get it into a decimal.

So I regex 'd the string and dumped the $. Debug mon shows a clean string
"14.95"

Then I do a System.Convert. ToDecimal on the clean string and the output
becomes: 1495

What gives!? I've tried a variety of workarounds but nothing works. How
can I format it for 2 decimal places or perform the convert in a way I am
not aware of?

Thanks alot!

[Jakob Christensen]

It has to do with the culture of the running thread. See the docs for
System.Threadin g.Thread.Curren tCulture, System.Globaliz ation.CultureIn fo and
System.Globaliz ation.NumberFor matInfo. The property NumberDecimalSe parator
of the class System.Globaliz ation.NumberFor matInfo specifies the decimal
separator to be used for parsing etc.

You can always change the culture for your thread if you wish.

Regards, Jakob.
"BA" wrote:

"Peter Mancini" <pe***********@ gmail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Show us the code. Copy it from your program. Might be a syntax issue.

Thanks for the response, here is the code (cutout try catch for ease of
reading, other funciton just returns the decimal:

>>>>>>>>>>>> code>>>>>>>>>>> >>>>>
public decimal Lookup(string ISBN)
{
string CleanPrice;
decimal decCleanPrice;

System.Diagnost ics.Trace.Write Line("AmazonWeb ServiceDLL:Amaz onLookupAdapter
ENTER");

//Create Instance of Proxy Class
SService as1 = new SService ();

SService.lookup = ISBN;

CleanPrice = as1.AsinSearchR equest(asin);

CleanPrice =
System.Text.Reg ularExpressions .Regex.Replace( pi.Details[0].OurPrice,Syste m.Text.RegularE xpressions.Rege x.Escape("$"),
"");
System.Diagnost ics.Trace.Write Line("price: " + CleanPrice);

decCleanPrice = ConvertStringDe cimal(CleanPric e.ToString());

System.Diagnost ics.Trace.Write Line(System.Con vert.ToString(d ecCleanPrice));
System.Diagnost ics.Trace.Write Line("EXIT");

return decCleanPrice;
}

internal decimal ConvertStringDe cimal(string stringVal)
{
decimal decimalVal;

try
{
decimalVal = System.Convert. ToDecimal(strin gVal);
System.Diagnost ics.Trace.Write Line("The string as a decimal is {0}.",
decimalVal.ToSt ring());
return decimalVal;

}
catch (System.Overflo wException)
{
System.Diagnost ics.Trace.Write Line("The conversion from string to
decimal overflowed.");
return 0;
}
catch (System.FormatE xception)
{
System.Diagnost ics.Trace.Write Line("The string is not formatted as a
decimal.");
return 0;
}
catch (System.Argumen tNullException)
{
System.Diagnost ics.Trace.Write Line("The string is null.");
return 0;
}
}

}
}
>>>>>>>>>> code>>>>>>>>>>> >>>>>

Thanks again