Skip to main content
Question

How can I extract text from Service Fusion description field and add to Smartsheet row?

  • October 11, 2024
  • 4 replies
  • 25 views

Im using the Service Fusion app and adding data to Smartsheet row. I want to extract just the qty of windows and doors from the description so that it can be added to my zap and in turn to my Smartsheet row

 

 

 

 

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

4 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • October 14, 2024

Hi @LAndersen2210,

You can use Formatter by Zapier to extract the text that you’re looking for. Here is the list of the Formatter by Zapier functions: https://help.zapier.com/hc/en-us/articles/8496030096013-How-to-use-Formatter-functions

Additionally, you can use RegEx to find text in Zaps. More about that here: https://help.zapier.com/hc/en-us/articles/8496278106637-Use-regular-expressions-RegEx-to-find-text-in-Zaps#h_01HKMCV6BA480X58EPVA8TJTQF

Hopefully, this helps.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • October 22, 2024

Hey there, @LAndersen2210! 👋

How did you get on with that Formatter action Ken suggested? Did it allow you able to extract the quantity of windows and doors from the Description field?

We’d love to know whether that fixed the problem so we can mark it as the best answer. And if you’re still facing challenges, just let us know—we’re happy to assist further!


  • Author
  • Tinkerer
  • October 22, 2024

I haven't had a chance to try it yet but I hope to get to it this week 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • October 23, 2024

Hi @LAndersen2210,

Please keep us posted on this! If my suggestion didn’t solve the issue, we’re more than happy to troubleshoot further! 🤗