Skip to main content
Solved

Formula to pull a Headline on Content Calendar


I'm trying to improve the content calendar we are using. I have a Content Field, which is the full post that we're going to copy and paste into Facebook. I'd like to have a column that will pull just the first line of the post using a formula. Any ideas on how to do this? 

For example, here is a post that would be in the content field:

๐ŸŒŸ Fun-filled Learning at Ditebogo Daycare in Video Informal Settlement!

These awesome educators are all about hands-on learning experiences for their kiddos. Recently, they organized a super-fun day filled with science experiments, face painting, and, wait for it... ice cream! ๐Ÿฆ๐ŸŽจ๐Ÿ”ฌ

Speaking of science, do you remember playing with Oobleck as a child? It's that magical goo that can be both a liquid and a solid depending on how you touch it.

Now, here's the best part - Ditebogo Daycare isn't all about keeping the kids clean and tidy all the time. Nope, they believe in letting kids be kids and learn through experience! ๐Ÿ™Œ

These little scientists had a blast discovering different states of matter through play, and you can bet they'll remember this day for a long time! ๐Ÿงช๐ŸŽˆ

Stay tuned for more inspiring stories!
#AFFTZA #HandsOnLearning #ScienceFun #LetKidsBeKids

 

I would like a formula to pull just "๐ŸŒŸ Fun-filled Learning at Ditebogo Daycare in Video Informal Settlement!" into a Title Field. Any ideas?

Best answer by Sho

This formula gets the first paragraph (the text up to the first two line breaks).

REGEX_EXTRACT({Text}, "((.\n?)*)\n\n")

 

View original
Did this topic help you find an answer to your question?

2 replies

  • Inspiring
  • 560 replies
  • Answer
  • September 14, 2023

This formula gets the first paragraph (the text up to the first two line breaks).

REGEX_EXTRACT({Text}, "((.\n?)*)\n\n")

 


  • Author
  • Known Participant
  • 12 replies
  • September 14, 2023
Sho wrote:

This formula gets the first paragraph (the text up to the first two line breaks).

REGEX_EXTRACT({Text}, "((.\n?)*)\n\n")

 


Amazing - exactly what I needed! 

Thank you ๐Ÿ™‚ 


Reply