Best answer

How to extract last item from a field using Formatter?

  • 22 July 2021
  • 3 replies
  • 19 views

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

 

icon

Best answer by a1angeles 28 July 2021, 01:37

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.

View original

3 replies

Userlevel 6
Badge +6

Hi @a1angeles 

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.

Userlevel 5
Badge +8

Glad you figured this one out and thanks for sharing your solution with us, @a1angeles! :)

Reply