MSFN Forum: Further breakdown data from "New Web Query" - MSFN Forum

Jump to content



Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Further breakdown data from "New Web Query" Rate Topic: -----

#1 User is offline   va1damar 

  • Group: Members
  • Posts: 2
  • Joined: 18-October 06

Posted 18 October 2006 - 11:51 AM

When I use Data->Import External Data ->New Web Query I can select a block containing the text that I want (a price), but a lot of other stuff is often imported also. While I may recieve all of the following data:

+--------+---------+ 
| Color: |BLACK	| 
+--------+---------+ 
| Stock: |Available| 
+--------+---------+ 
| Price: |$439.00  | 
+--------+---------+


the only thing i want is the price $439.00. I want to insert that price (and nothing else) into specific cells in an existing spreadsheet that calculates price comparisons. Is there a way to parse out the cell containing $439.00 from everything that I get from the Web Query?


Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2011 msfn.org
Privacy Policy