String to decimal

sthe · Post by **sthe** » Wed May 04, 2011 8:39 am

hello
in my report i have a database field in the form of e.g "0.5 STD","4.5 STD", "1,5 STD" etc
how to do i convert this string into the decimal without the " STD"?

thank you in advance

Post by **Ivan** » Fri May 06, 2011 8:30 am

Hello,

Please try to use the following expression, for example:

Code: Select all

{decimal.Parse(yourField.Substring(0, yourField.Length - 4))}

Thank you.

sthe · Post by **sthe** » Mon May 16, 2011 7:27 am

hi,
worked perfectly
thank you very much

Post by **Andrew** » Mon May 16, 2011 2:03 pm

Great!

Have a nice day!
Thank you.