Jump to content

Google Docs html help needed


GreenFire63

Recommended Posts

I have a technical problem with google docs. As I'm sure some of you are aware, you can use google docs to track xp, store current ge prices, make calculators, etc etc. I'm making a list of items that I need and merchant frequently. Importing the data was no problem, the problem comes with calculating daily percent changes. When you import price change information from the rs item database, it attaches a plus and a minus to signifiy increases or falls. For some reason, Google docs is having difficulty understanding that a plus means positive. No issues on the minus symbol though.

 

 

 

I'm guessing that the plus sign is considered text, which is why it screws up my calculations. (though that doesn't explain why the minus works) I would just delete the plus sign, but since the data is imported from an html table you can't exactly do that. I've tried doing "=Value(text)" but that doesn't work. Could someone experienced with html help me out with this problem? An html code deleting the plus sign or a code for google docs to understand that it means positive would be GREATLY appreciated.

 

 

 

Below is the code I used to import data:

 

=Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=cosmic rune", "table", 2),2)

 

 

 

And code I used to convert k's and m's to *1000 and *10000000

 

=if(iferror(find("m"C50),false),left(C50,find("m",C50)-1)*1000000,if(iferror(find("k",C50),false),left(C50,find("k",C50)-1)*1000,C50))

 

 

 

^both from "How to use Google Docs to extract GE prices ~By Brainymidget" found at viewtopic.php?f=180&t=782319

 

 

 

My knowledge of html is fairly limited lol, but maybe its possible to use my conversion code to change "+" to a space or *1? Maybe work off of this fail code? hahaha

 

 

 

=if(iferror(find("+"D4),false),left(D4,find("+",D4)-1)*1,D4)

 

 

 

^it didn't work for me btw hahaha

 

 

 

Thanks :)

Billionaire status as of 7/19/2009

Link to comment
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
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.