Tassilo Posted May 25, 2009 Share Posted May 25, 2009 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 kaufenMy 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. Link to comment Share on other sites More sharing options...
oMBRa Posted May 25, 2009 Share Posted May 25, 2009 search in the help file for StringReplace() Link to comment Share on other sites More sharing options...
Juvigy Posted May 25, 2009 Share Posted May 25, 2009 In your regional settings of windows you can specify the thousands separator and the decimal separator. Link to comment Share on other sites More sharing options...
Tassilo Posted May 25, 2009 Author Share Posted May 25, 2009 Thanks guys, I've got it now. $test = StringReplace(ClipGet(), ".", "") ...does the trick. Thanks for the quick replies. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now