Translations:StrExpression/33/en

Mathematical expression that can contain:

• Whole numbers
• Strings(e.g. "abc")
• Variables A, B, C, D, E, F, G a H
• Operators (+, -, *, /, %, <, >, <=, >= , ==, !=, !, <<, >>, ^, &, |, &&, ||)
• Parentheses ( )
• Functions:

length(string str)

pos(string str, string substr)

substr(string str, int offset)

substr(string str, int offset, int length)

trim(string str)

replace(string str, string from, string to)

replace(string str, string from, string to, bool replace_all)

lowercase(string str)

uppercase(string str)

if(bool condition, string then, string else)

strip_diacritics(string str)

regex_match(string text, string expression)

regex_match(string text, string expression, int group)

regex_search(string text, string expression)

regex_search(string text, string expression, int group)

regex_replace(string text, string expression, string replacement)

regex_replace(string text, string expression, string replacement, bool replace_all)

toTimestamp(string str, string format)

formatTimestamp(int epochTime, string format)