Skip to main content
Question

How do I clean and format RSS feed content to remove codes and add plain text?

  • June 5, 2024
  • 8 replies
  • 193 views

HI.

 

BASICALLY WE ARE EXTRACTING NEWS ARTICLE TO A DIFFERENT WEBSITE USING RSS FEED HOWEVER, WHEN THE CONTENT IS ADDED THERE ARE SOME CODES ADDED IN IT. HOW DO I CLEAN IT OR FORMAT IT PROPERLY SO I CAN JUST ADD PLAIN TEXT TO IT?


See sample

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • June 5, 2024

Hi @ME12345 

You would need to be more specific with what you exactly mean by the “codes” that are added. (examples)


  • Author
  • Beginner
  • June 6, 2024

See the text in the photo there are added codes like this “|| {cmd: []}; googletag.cmd.push(function() { googletag.defineSlot('/21776187881/fw-responsive-main_content-slot2', [[468, 60], [728, 90], [300, 100], [320, 50]], 'div-gpt-ad-1665767472470-0').defineSizeMapping(gptSizeMaps.banner1).”

 

 


  • Author
  • Beginner
  • June 6, 2024

I managed to remove the HTML using the Remove HTML Tags.

 

------------------------------------------------------------------

 

Now I want to separate the article by paragraphs and I use code by zapier. do you think i can fix the format?

 

 

See how the spaces looks like

 

​​​​

 

See how the article looks like

 

 

 

How can i retain the format like that?

 

Thanks.

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • June 6, 2024

@ME12345 

Another option to consider trying is to use AI to help you parse and prep the data.

ChatGPT: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions

OpenAI: https://zapier.com/apps/openai/integrations#triggers-and-actions


  • Author
  • Beginner
  • June 6, 2024

For some reason it now becomes super messy. 😑


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • June 6, 2024

@ME12345 

Trying to parse and prep data that varies in format can be a challenge.

You may want to have AI summarize the contents, then format from that output.


  • Author
  • Beginner
  • June 6, 2024

Do you have any sample steps I can follow with how you use the AI to summarize the content?

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • June 6, 2024

@ME12345 

Really depends on your requirements.

Here’s an option...

Zap action: OpenAI - Summarize Text