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
Page 1 / 1
Hi
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.
Hey there, 
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!
I haven't had a chance to try it yet but I hope to get to it this week
Hi
Please keep us posted on this! If my suggestion didn’t solve the issue, we’re more than happy to troubleshoot further! 
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.