How to extract a paragraph from a cell?

asked 2016-06-19 23:43:29 -0500

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi, I'm new to this.

I've scraped an RSS feed of a weather forecast. They've put all nine days under the same XPATH.. so the cell has all the text including a general overview of the day.

What I want is to have the spreadsheet: Scrape the RSS feed often. Sort the forecasts into daily reports find within those reports a value such as rainy, windy, cloudy, sunny etc. then if one of those values exists I can report a hyperlink in another cell (using CONCAT) which would give an image.

Seems simple but I have no idea how to do this. Anyone?


edit retag flag offensive close merge delete