• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Enhancement Requests Application Enhancements
R

Rachel Beck

started a topic over 4 years ago

implement #{} notation in formula processor

When using functions that take regex inputs, Workato will only allow "literal" regex inputs to be used in those functions.


Example:

"My Workato subscription costs 123.45 dollars".scan(/[0-9]{1,6}[.][0-9]{2}/)


will yield an array of ["123.45"]


However, I want the regex value of [0-9]{1,6}[.][0-9]{2} to come from a previous Data Pill.  In normal Ruby, I would do the following:

r = "[0-9]{1,6}[.][0-9]{2}"

"My workato subscription costs 123.45 dollars".scan(/#{r}/)


This would yield  ["123.45"].  


However, the ruby formula processor in Workato does not support #{} notation.


Could Workato implement it?

Amanda Wong

said over 4 years ago

Hi Rachel, 


The formula mode does not currently support regex inputs from data pills. However, this is possible using the Ruby connector. I have created a recipe for your reference. Let us know if this works for you.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count