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"