Needing to identify dollar figures over $10k in a string

[Sheri]

Hi guys

I’m needing to identify if a figure of $10,000.00 or more appears in a string.

I assume it’s regex matching but I haven’t done that before!

The figure will appear similar to this:
10000.00

No dollar sign, no spaces, and includes 2 decimal places, and it can be any figure over $10,000.00.

I don’t need it to tell me every instance of $10k or more, just if it appears at all.

Thanks in advance!

[garywjd91]

since you know you can try to extract similar strings with regex. why not work towards in understanding regex and write one for the string that you mentioned.

after which you try to parse it as a double.

you should take the initiative to learn stuff to accomplish what you are doing instead of asking others to feed you with the solution.

[loginerror (Maciej Kuźmicz)]

Hi @Sheri

Could you give this topic a look?

Remove 0 from end of String

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? Thanks!

You could also see here.

[Sheri]

Thanks