I’m trying to work with a public RSS feed that shows weather data. The RSS feed has 1 field (called “Description”) that shows a bunch of measurements/info. The last item in that field is Water Temperature in °F and °C.
I need to extract just the Water Temperature measurements and pass that along to the next step.
I’m using the Formatter app → Action Event is “Utilities → Transform is “Pick from list” → Operation is “Choose last.” Next step (Insert Data) is to select the “Description” field. So far so good, but the output is, like, 90% of the measurements/info when I only need the last 10%. I don’t see a way for me to specify the last x characters or select the text immediately after the constant title “Water Temperature.”
Any ideas on how to proceed?
This is the link to the RSS feed: https://www.ndbc.noaa.gov/data/latest_obs/46254.rss
Best answer by a1angelesView original
For this, I believe you need to use a function called RegEx, which can be found in Zapier by using Formatter> Text> Extract pattern.
Regex code can help you extract any information out of a paragraph. If you are new to RegEx, you may need to hire someone to write a piece of regex code for your case.
I found my own way to do this, without having to hire someone to write regex code.
Formatter by zapier → Split Text (after the constant “Water Temperature: “)
passes along the exact piece of data I needed.
Glad you figured this one out and thanks for sharing your solution with us,