FFAStrans wiki

Intro

We can sort functions in 3 groups :
1/ Character string functions
2/ Mathematics functions
3/ IT functions

1/ Character string functions :

• ALL string inputs containing alphabetic characters (a-z, A-Z) must be encapsulated with single or double quotes: “my string”, '123abc', “%s_variable%”, '%i_variable%'.
• If numeric character(s) (0-9) are used in functions that accept strings then the number will be treated as a string: 123 = “123”.

Here are the list of character functions :

 $left/$right/$middle/$replace/$upper/$lower/$stripws/$stripcrif/$length/$isdigit/$isalph/$reverse/$triml/$trimr/$leads/$trails/$between/$proper/$alrep

All these functions will manipulate character strings to fit your needs. Functions can use into conditional node and populate variable node and keep the result in a variable.

Usage description : $function(input-1 = “string”, input-2 = integer[, optional input-3 = “string”/integer])
The same example sentence will be used to illustrate these character string functions: “Function number 131 is useful”

• $left : Get string n-characters from the left side.
• $triml : Trim string n-characters from the left side.

Usages:
$left(input string = “string/%variable%”, number of characters to extract = integer/%i_variable%)
$triml(input string = “string/%variable%”, number of characters to trim = integer/%i_variable%)

• $right : Get string n-characters from the right side.
• $trimr : Trim string n-characters from the right side.

Usages:
$right(input string = “string/%variable%”, number of characters to extract = integer/%i_variable%)
$trimr(input string = “string/%variable%”, number of characters to trim = integer/%i_variable%)

• $middle : Get string n-characters from n-position.
• $between: Get string between two strings.

Usages:
$middle(input string = “string/%variable%”, start position = integer/%i_variable%, number of characters to extract from start position = integer/%i_variable%)
$between(input string = “string/%variable%”, from string = “string/%variable%”, to string = “string/%variable%”[, instance found= integer/%i_variable%])

• $upper : Force string to upper case.
• $lower : Force string to lower case.
• $proper: Capitalizes every first letter following a non-alphanumeric character.

Usages:
$upper(input string = “string/%variable%”)
$lower(input string = “string/%variable%”)
$proper(input string = “string/%variable%”)

$replace and $alrep:

Usage:
$replace(input string = “string/%variable%”, string to replace = “string/%variable%” [, replace with string = “string/%variable%”, type = 0])
$alrep(input string = “string/%variable%”[, replace with string = “string/%variable%”][, except characters = “string/%variable%”])