VB.Net Remove trailing zeros

Question

I am saving a scraped number as a string (ex: $12.50) and comparing it to an excel table that has numbers as (ex: 12.5). I was using: Replace(“0”, “”) to get rid of the zeroes but it removes zeroes in a number such as .034.

How do I remove the dollar sign from the front and also remove zeroes that might be on the end of the string?

Use `decimal.parse()` with `NumberStyles.Currency`. https://msdn.microsoft.com/en-us/library/91fwbcsb(v=vs.110).aspx — Paul Abbott, Aug 10 '18 at 21:29
Can you show what that would look like with a string var: strVar. It would really help — mike Johnson, Aug 10 '18 at 21:48
Possible duplicate of [Remove trailing zeros](https://stackoverflow.com/questions/4525854/remove-trailing-zeros) — γηράσκω δ' αεί πολλά διδασκόμε, Aug 10 '18 at 23:36
The dollar sign is easy to remove with `Replace("$", "")`. The *trailing zeros* is a duplicate [Remove trailing zeros](https://stackoverflow.com/questions/4525854/remove-trailing-zeros) — γηράσκω δ' αεί πολλά διδασκόμε, Aug 10 '18 at 23:40
Are you comparing strings or numbers? If numbers, 12.50 = 12.5 — Mary, Aug 11 '18 at 03:17

score 1 · Answer 1 · answered Aug 11 '18 at 10:32

You can use the string function ,TrimEnd(char) and .TrimStart(char)

This example will trim any trailing zeros and the dollar sign and, if your string has started as "12.00" it will also remove the decimal point, but only if there are no digits after the decimal point.

Dim st As String = "$12.50" 
st = st.TrimEnd("0"c).TrimEnd("."c).TrimStart("$"c)

Although as other people have commented, you would be much better parsing it to Decimal type as early as posible in your code. Trying to work with numbers stored as strings is a recipe for problems.

VB.Net Remove trailing zeros

1 Answers1