• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Tips & Tricks!

Adam Goh

started a topic over 7 years ago

Formula mode : Helpful string functions


Workato formula mode supports many functions. These are very useful for advanced users, especially when used in conjunction with each other. You can use them to do an If-then using (? :). Put your true statement after ? and false statement after :


Workato formula mode supports many functions. These are very useful for advanced users, especially when used in conjunction with each other.


Hopefully no explanation is needed for these examples listed below. If you find any of them needing further explanation please file a ticket.


'jean marie'.blank?

=> false


'Jean Marie'.exclude?('Jean')

=> false


'Jean Marie'.include?('Jean')

=> true


'Jean Marie'.match?('ie')

=> true 


'Jean Marie'.match?('ma')

=> false 


'Jean Marie'.match?('Ma')

=> true 


'Jean Marie'.match?('Jean Marie')

=> true


'Jean Marie'.match?('Jean Mariee')

=> false


'Jean Marie'.include?('Ma')



=> true


'Jean Marie'.ends_with?('ie')

=> true


'Jean Marie'.starts_with?('ie')

=> false


'jean marie'.capitalize

=> "Jean marie" 

 

'Jean Marie'.titleize

=> "Jean Marie" 

 

'Jean Marie'.upcase

=> "JEAN MARIE" 


'Jean Marie'.downcase

=> "jean marie" 


' Jean Marie'.lstrip

=> "Jean Marie"


' Jean Marie '.rstrip

=> " Jean Marie"


' Jean Marie '.rstrip.lstrip

=> "Jean Marie"


' Jean Marie '.strip

=> "Jean Marie" 



' Jean Marie'.length

=> 11


' Jean Marie '.reverse

=> " eiraM naeJ "


'Jean Marie'.gsub('J', 'M')

=> "Mean Marie"


'Jean Marie'.gsub('e', 'i')

=> "Jian Marii"





3 people like this idea
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 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count