To learn about using the Script Line Editor functions, see
Adding Script Tags Overview.
Absolute
(Expression N1)
Description 
Return the absolute value of a given number. 
Arguments 
Expression N1 is the number to be processed. 
Return 
A character string which holds a number. The function will return the absolute value of Expression N1. 
Examples 
Example 1 
ABSOLUTE (1000) 
Result 
1000 
Example 2 
ABSOLUTE (1000.54) 
Result 
1000.54 
Append String
Description 
Append a string to another string. 
Arguments 
is the string being appended with the string. is the string to append to . determines from which side of to append the character. Valid values are: ‘R’ (Right), ‘L’ (Left). Default value is ‘L’. 
Return 
A Character string. The function will return the after being appended with character from the side specified in . 
Examples 
Example 1 
APPEND STRING (abcdabxyz,efgh,L) 
Result 
efghabcdabxyz 
Example 2 
APPEND STRING (abcdabxyz,efgh,R) 
Result 
abcdabxyzefgh 
Compress Character
(Expression C1, Expression C2)
Description 
Replace duplicate appearances of a character in a string with a single appearance. 
Arguments 
Expression C1 is the string being searched for the duplicated Expression C2 character. Expression C2 is the character being searched in Expression C1 for duplicated appearances. 
Return 
A character string. The function will return the Expression C1 after replacing the duplicated appearances of Expression C2 with a single appearance. 
Examples 
Example 1 
Compress character (ab cdabxy z,SPACE) 
Result 
ab cdab xy z 
Example 2 
COMPRESS CHARACTER (abbbcdabxybz,b) 
Result 
abcdabxyzb 
Example 3 
COMPRESS CHARACTER (00 1000,0) 
Result 
010 
External Calculate Capitalized Interest
(Expression N1, Expression N2, Expression N3)
Description 
Calculate the capitalized interest of a given amount based on specified interest rate and the number of months. 
Arguments 
Expression N1 is the original amount to use for the interest calculation. Expression N2 is the interest rate to use for the capitalized interest calculation. Expression N3 is the period of time (number of months) to use for the capitalized interest calculation. 
Return 
A character string. The function will return the calculated capitalized interest amount of expN1 based on the interest rate specified in expN2 and the number of months specified in expN3. 
Examples 
Example 1 
External CALCULATE CAPITALIZED INTEREST (100000,3.5,20) 
Result 
4350 
External Calculate ID Digit
(Expression N)
Description 
Calculate the personal ID control digit according to the Israeli standards. 
Arguments 
Expression N is the personal ID number without the control digit. 
Return 
A character string. The function will return the personal ID in expN with the calculated control digit. 
Examples 
Example 1 
External CALCULATE ID DIGIT (5459174) 
Result 
54591748 
External Use DB
(Expression C1, Expression C2, Expression C3, Expression C4, Expression C5)
Description 
Extract a value from an external database according to various parameters. 
Arguments 
Expression C1 is the database name. Expression C2 is the table name to use in expC1 database. Expression C3 is the index scheme to use in expC2 table for the required value extraction. Expression C4 is field value to search for in expC2 table. Expression C5 is the field name in expC2 to extract value from.

Return 
A character string. The function will return the value of expC5 field based on the parameters specified in expC1, expC2, expC3 and expC4. 
Examples 
Example 1 
External USE DB (Customers, info, name, John Smith, address) 
Result 
Penny Lane 12, London 
Integer
Description 
Extract the integer value of a number. 
Arguments 
is the number to be processed. 
Return 
A character string which holds the integer value of . 
Examples 
Example 1 
INTEGER (9.35) 
Result 
9 
Example 2 
INTEGER (9) 
Result 
9 
Example 3 
Result: 9 
Result 
9 
Mantissa
(Expression N1, Expression N2)
Description 
Calculate the mantissa value of a number modulus by another number. 
Arguments 
Expression N1 is the number modulated by Expression N2.
Expression N2 is the modulus number used with Expression N1. 
Return 
A character string which holds the mantissa value of Expression N1 modulus Expression N2. 
Examples 
Example 1 
MANTISSA (10,3) 
Result 
1 
Examples 
Example 2 
MANTISSA (9,3) 
Result 
0 
Example 3 
MANTISSA (55.45,3.27) 
Result 
3.13 
Max String Length
(Expression C1, Expression N1, Expression C2)
Description 
Set the maximum length of a string. 
Arguments 
Expression C1 is the string being processed according to the maximum length specified in Expression N1. Expression N1 is the maximum allowed length of Expression C1.
Expression C2 determines from which side of Expression C1 to reduce the extra characters according to the maximum length specified in Expression N1. Valid values are: ‘R’ (Right), ‘L’ (Left). Default value is ‘L’. 
Return 
A character string. The function will return Expression C1 after reducing it size to the maximum length specified in Expression N1 from the side specified by Expression C2. If the Expression C1 string length is smaller than the value specified by Expression N1, the Expression C1 string will be returned. 
Examples 
Example 1 
MAX STRING LENGTH (abcdabxyz,4,L) 
Result 
abcd 
Example 2 
MAX STRING LENGTH (abcdabxyz,4,R) 
Result 
abxyz 
Example 3 
MAX STRING LENGTH (abcdabxyz,15,L) 
Result 
abcdabxyz 
Pad String
(Expression C1, Expression N1, Expression C2, Expression C3)
Description 
Add a repeating character to a string according to the maximum desired length of the whole string. 
Arguments 
Expression C1 is the string being processed. Expression N1 is the desired new length of Expression C1 after padding it with Expression C2. Expression C2 is the character to pad Expression C1. Expression C3 determines from which side of Expression C1 to pad the Expression C2 character. Valid values are: ‘R’ (Right), ‘L’ (Left). The default value is ‘L’. 
Return 
A character string. The function will return the Expression C1 after being padded with Expression C2 character to the max length specified in Expression N1 starting from the side specified in Expression C2. If Expression C1 string length is equal or bigger than Expression N1, no padding will be performed. 
Examples 
Example 1 
PAD STRING (abcdabxyz,15,e,L) 
Result 
eeeeeeabcdabxyz 
Example 2 
PAD STRING (abcdabxyz,13,f,R) 
Result 
abcdabxyzffff 
Example 3 
PAD STRING (abcdabxyz,8,g,L) 
Result 
abcdabxyz 
Power
(Expression N1, Expression N2)
Description 
Calculate the mathematical power value of a number. 
Arguments 
Expression N1 is the number to be processed. Expression N2 is the power value to be used with Expression N1. 
Return 
A character string which holds the power Expression N2 of Expression N1. 
Examples 
Example 1 
POWER (9,2) 
Result 
81 
Example 2 
POWER (3,3) 
Result 
27 
Remove String
(Expression C1, Expression C2)
Description 
Remove all occurrences of a given string. 
Arguments 
Expression C1 is the string being processed. Expression C2 is the string to search for in Expression C1 and remove. 
Return 
A character string. The function will return the Expression C1 string after removing all occurrences of Expression C2. 
Examples 
Example 1 
REMOVE STRING (abcdabxyz,ab) 
Result 
cdxyz 
Example 2 
REMOVE STRING (abcdabxyz,abc) 
Result 
dabxyz 
Example 3 
REMOVE STRING (1000,0) 
Result 
1 
Replace String
(Expression C1, Expression C2, Expression C2)
Description 
Replace all occurrences of a given string with another string. 
Arguments 
Expression C1 is the string being processed. Expression C2 is the string to search for in Expression C1 and replace with the string specified in Expression C3. Expression C3 is the string to replace Expression C2 in Expression C1. 
Return 
A character string. The function will return the Expression C1 string after replacing all occurrences of Expression C2 with Expression C3. 
Examples 
Example 1 
REPLACE STRING (abcdabxyz,ab,gh) 
Result 
ghcdghxyz 
Example 2 
REPLACE STRING (abcdabxyz,abc,gh) 
Result 
ghdabxyz 
Example 3 
REPLACE STRING (1.1.2008,.,) 
Result 
112008 
Round
(Expression N1)
Description 
Round the value of a floating number. 
Arguments 
Expression N1 is the number to be processed. 
Return 
Character string which holds the rounded value of Expression N1. 
Examples 
Example 1 
ROUND (9.49) 
Result 
9.00 
Example 2 
ROUND (9.5) 
Result 
9.00 
Example 3 
ROUND (9.51) 
Result 
10.00 
String Position
(Expression C1, Expression C2, Expression C3, Expression N1)
Description 
Return the starting position of a string within another string. 
Arguments 
Expression C1 is the string in which Expression C2 should be searched for. Expression C2 is the string being searched in Expression C1 string. Expression C3 determines from which side of Expression C1 to start the search for Expression C2. Valid values are: ‘R’ (Right), ‘L’ (Left). The default value is ‘L’. Expression N1 is the requested appearance number Expression C2 in Expression C1. 
Return 
A character string. The function will return the position where the Expression C2 string starts in Expression C1. If the Expression C2 cannot be found in Expression C1, the function will return 0 (zero). 
Examples 
Example 1 
STRING POSITION (abcdabxyz,ab,L,1) 
Result 
1 
Example 2 
STRING POSITION (abcdabxyz,ab,R,1) 
Result 
4 
Example 3 
STRING POSITION (abcdabxyz,ab,L,2) 
Result 
5 
Example 4 
STRING POSITION (abcdabxyz,ef,L,1) 
Result 
0 
Sub String
(Expression C1, Expression N1, Expression N2, Expression C2)
Description 
Extract a string from another string. 
Arguments 
Expression C1 is the string to extract from starting from the side specified in Expression C2 using the offset position specified in Expression N1 in length specified by Expression N2. Expression N1 is the offset position in Expression C1 to extract the desired string starting from the side specified by Expression C2. Expression N2 is the maximum length of the string to extract from Expression C1. Expression C3 determines from which side of Expression C1 to calculate the offset position specified in Expression N1. Valid values are: ‘R’ (Right), ‘L’ (Left). Default value is ‘L’. 
Return 
A character string. The function will return the string extracted from Expression C1 according to the offset position specified in Expression N1 and maximum length specified by Expression N2. If the specified maximum length is beyond the Expression C1 boundary, the extracted string length will not exceed this boundary. 
Examples 
Example 1 
SUB STRING (abc dabx yz,1,5,L) 
Result 
abc d 
Example 2 
SUB STRING (abc dabx yz,3,5,L) 
Result 
c dab 
Example3 
SUB STRING (abc dabx yz,1,5,R) 
Result 
bx yz 
Example 4 
SUB STRING (abc dabx yz,4,2,R) 
Result 
bx 
Example 5 
SUB STRING (abc dabx yz,7,9,L) 
Result 
bx yz 
Table Column Average
Description 
Calculate the average value of all values appearing in a column.
Note: This script cannot be used inside a table. 
Arguments 
Expression C is the name of the table column. 
Return 
Character string which holds a number.
The function will return the average value of Expression C. 
Examples 
Example 1 
Table Average (Tag Name) 
Result 
Average of values 
Table Column Sum
Description 
Sum all of data tag values of a specific tag.
This function can only be added to the Form in a script tag (not a tag converted to a script).
Note: When you add the script inside a table, the sum includes only values displayed in the table output. For example, in a filtered table only items displayed in the filtered table are summed.
Note that the script should not be added in the same row as the table tags.
If you add the script outside the table all values are summed. 
Argument 
Expression C is the name of the table column. 
Return 
Character string which holds a number.
The function will return the sum of the values of Expression C. 
Examples 
Example 1 
Table Sum (Tag Name) 
Result 
Sum of the selected columns 
Table Row Count
Description 
Total number of table rows in the input.
Note: This script cannot be used inside a table. 
Arguments 
Expression C is the name of the table column. 
Return 
Character string which holds a number.
The function will return the number of table rows of Expression C. 
Examples 
Example 1 
Table Row Count (Tag Name) 
Result 
Number of rows 
Table Row Position
Description 
Number table row according to the position number of the row in the input. 
Return 
The function returns a row value that corresponds to the row position. 
Trim Character
(Expression C1, Expression C2, Expression C3)
Description 
Remove a repeated character from a string end(s). 
Return 
A character string. The function will return the Expression C1 string after trimming the Expression C2 repeated character at its end(s). 
Examples 
Example 1 
TRIM (abcdefg, SPACE, B) 
Result 
abcdefg d 
Example 2 
TRIM (00001000, 0, L) 
Result 
c 1000 
Example 3 
TRIM (abcdefghhhhhh, h, R) 
Result 
bx abcdefg 
Truncate String
(Expression C1, Expression N1, Expression C2)
Description 
Cut the length of a string by specified number of characters. 
Arguments 
Expression C1 is the string being cut by Expression N1 number of characters. Expression N1 is the number of characters to cut from Expression C1. Expression C2 determines from which side of Expression C1 to cut the number of characters specified by Expression N1. Valid values are: ‘R’ (Right), ‘L’ (Left). Default value is ‘L’. 
Return 
A character string. The function will return the Expression C1 after deleting the number of characters specified by Expression N1 from the side specified by Expression C2.
If the Expression C1 string length is smaller than the value specified by Expression N1, an empty string will be returned. 
Examples 
Example 1 
TRUNCATE STRING (abcdabxyz,3,L) 
Result 
dabxyz 
Example 2 
TRUNCATE STRING (abcdabxyz,2,R) 
Result 
abcddabx 
Example 3 
TRUNCATE STRING (abcdabxyz,10,L) 
Result 
NULL 