Jump to content
Sign in to follow this  
Tassilo

Q: How to ClipGet() numbers without the 1000-separator

Recommended Posts

Tassilo

I would like to extract price data from a website, calculate an average price and post it into openoffice/Excel.

The data from the website looks like this:

Anzahl     Produkt  Firma                 Quali  Preis         Gesamt         Aktion
200       Stahl   muenchenAG             0       159,00       31.800,00    kaufen
2.112       Mehl       Idea Network Ltd    0         39,00         82.368,00       kaufen
600       Getreide   BierFabrik          2        8,00          4.800,00        kaufen
1.000       Getreide   Schmu Schubiak        0       7,77           7.770,00        kaufen
45.000     Strom      Lindi GmbH             0        0,16          7.200,00        kaufen

My problem here is that whenever i mark the "Anzahl" number (The number of items) and get it with CLIPGET(), a "." is treated as a ",".

That means the 2.112 (two thousand one houndred and twelve) are treated as 2,112 (two point one one two).

Do you guys know how I can remove that "." or somehow mark the 2.112 and have it register as two thousand something? I'm clueless and new to autoIt, so please help me.

Share this post


Link to post
Share on other sites
oMBRa

search in the help file for StringReplace()

Share this post


Link to post
Share on other sites
Juvigy

In your regional settings of windows you can specify the thousands separator and the decimal separator.

Share this post


Link to post
Share on other sites
Tassilo

Thanks guys, I've got it now.

$test = StringReplace(ClipGet(), ".", "")

...does the trick.

Thanks for the quick replies.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.