Jump to content

Further breakdown data from "New Web Query"


Recommended Posts

Posted

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?


Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...