How to extract last item from a field using Formatter?

Question

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

a1angeles · Accepted Answer

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.

robschmidt · Answer

Hi @a1angelesFor 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.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded