This section introduces string functions used for report making by listing their descriptions, syntax, parameters, return values and options, and giving related examples.
Description:
Get the Unicode value of a character at the specified position in a string; return ASCII code if the character is recorded in ASCII.
(In general, all the English characters and their extended characters are ASCII characters; Asian language characters, such as Chinese, Japanese and Korean, are recorded in Unicode. ASCII is an 8-bit character set, and Unicode is a 16-bit character set, of which 3 bits are used to indicate the character type).
Related function: char() Get the corresponding characters according to the given Unicode or ASCII code.
Syntax:
asc( string{, nPos} )
Parameter:
|
string |
A given string |
|
nPos |
Integer expression, default is 1 |
Return value:
Integer type
Example:
Example 1: asc("def") Return 100 (ASCII)
Example 2: asc("def",2) Return 101 (ASCII)
Example 3: asc("中国") Return 20013 (Unicode)
Example 4: asc("中国",2) Return 22269 (Unicode)
Description:
Get the corresponding characters according to the given Unicode or ASCII code. (In general, all English characters and their extended characters are recorded in ASCII code; Chinese, Japanese, Korean, and other Asian characters are recorded in Unicode characters. ASCII is an 8-bit character set, and Unicode is a 16-bit character set, of which 3 bits are used to indicate the character type).
Related function: asc() Get the Unicode value of a character at the specified position in a string; return ASCII code if the character is recorded in ASCII.
Syntax:
char( int )
Parameter:
|
int |
Integer expression, Unicode code or ASCII code |
Return value:
Character type
Example:
Example 1: char(22269) Return '国'
Example 2: char(101) Return 'e'
Description:
Create a new string by concatenating strings together.
Related function: space() Generate an empty string.
Syntax:
fill(s, n)
Parameter:
|
s |
Source strings for generating a new string |
|
n |
Number of source strings that constitute the new string |
Return value:
Character type
Example:
Example 1: fill("1 ",10) Return "1 1 1 1 1 1 1 1 1 1 "
Example 2: fill("a b",10) Return "a ba ba ba ba ba ba ba ba ba b"
Description:
Judge if a string is composed of letters. If s is an integer, look it up in the ASCII table to see if the corresponding characters are letters.
Syntax:
isalpha(s)
Parameter:
|
s |
A string/ numeric expression |
Return value:
Boolean type
Example:
Example 1: isalpha("abc") Return true
Example 2: isalpha(97) Return true
Example 3: isalpha("@#$") Return false
Example 4: isalpha("1@23") Return false
Example 5: isalpha("a@23") Return false
Description:
Judge if a string is composed of numbers. If the string is an integer, look it up in the ASCII table to see if the corresponding characters are a number.
Syntax:
isdigit(string)
Parameter:
|
string |
A string/ numeric expression |
Return value:
Boolean type
Example:
Example 1: isdigit("123") Return true
Example 2: isdigit(123) Return false
Example 3: isdigit("abc") Return false
Example 4: isdigit("123ss") Return false
Description:
Judge if a string is composed of lower-case letters. If the string is an integer, treat it as ASCII code and judge if the corresponding characters are all lower-case letters.
Syntax:
islower(string)
Parameter:
|
string |
A string/ numeric expression |
Return value:
Boolean type
Example:
Example 1: islower ("dgfdsgf") Return true
Example 2: islower (97) Return true
Example 3: islower ("dsfaAFD") Return false
Example 4: islower ("97ffdsf") Return false
Description:
Judge if a string is composed of upper-case letters. If the string is an integer, treat it as ASCII code and judge if the corresponding characters are all upper -case letters.
Syntax:
isupper (string)
Parameter:
|
string |
A string/ numeric expression |
Return value:
Boolean type
Example:
Example 1: isupper ("ADSFDGKJ") Return true
Example 2: isupper (85) Return true
Example 3: isupper ("SDsdsSDAS") Return false
Example 4: isupper ("8ASDS7") Return false
Description:
Get a substring of length n starting from the leftmost side of a string. If n<0, the substring’s length is the sum of source string’s length and the value of n.
Related functions:
mid() Return the substring within a string.
right() Get a substring of a string ending at the rightmost side.
Syntax:
left(string, n)
Parameter:
|
string |
The source string from which the substring is obtained |
|
n |
The length of the substring |
Return value:
Character type
Example:
Example 1: left("abcdefg",3) Return "abc"
Example 2: left("abcdefg",-3) Return "abcd"
Description:
Compute the number of bytes in string s. When parameter cs, the character set, is absent, it gets the number of characters in the string and automatically uses GB2312 charset.
Syntax:
len(s,cs)
Parameter:
|
s |
A string |
|
cs |
A character set; can be omitted |
Return value:
An integer
Example:
Example 1: len("adfg") Return 4
Example 2: len(" abd ") Return 7
Example 3: len("报表") Return 2
Example 4: len("报表","GB2312") Return 4
Example 5: len("报表","UTF-8") Return 6
Example 6: len("报表", ) Return 4
Description:
Judge if a string matches a format string (the asterisk "*" matches 0 or multiple characters; and the question mark "?" matches a single character). An escape character is used to match "*", such as like ("abc*123", "abc\*"), which returns true.
Syntax:
like( stringExp, formatExp)
Parameter:
|
stringExp |
A string expression |
|
formatExp |
A format string expression |
Return value:
Boolean type
Option:
|
@c |
It makes the matching case-insensitive, while the default is case-sensitive |
Example:
Example 1: like( "abc123", "abc*" ) Return true
Example 2: like( "abc123", "abc1?3" ) Return true
Example 3: like( "abc123", "abc*34" ) Return false
Example 4: like( "abc123", "ABC*" ) Return false
Example 5: like("abc*123", "abc\*") Return true
Example 6: like@c("abc123", "ABC*") Return true
Description:
Generate a URL.
Syntax:
link(serviceName{,jspArgNames,jspArgValues{,reportArgNames,reportArgValues}})
Parameter:
|
serviceName |
Service name |
|
jspArgNames |
The array of argument names, which can be empty and where elements must be string type |
|
jspArgValues |
The array of argument values, whose length is the same as the number of elements in array jspArgNames |
|
reportArgNames |
The array of report argument names, which can be empty and where elements must be string type |
|
reportArgValues |
The array of report argument values, whose length is the same as the number of elements in array reportArgNames |
Return value:
String type
Example:
Example 1: link("ServiceName",list("jspArg1","jspArg2"), list("value1",2),"count",5)
Return ServiceName?jasArg1=value1&jspArg2=2¶ms=count=5
Description:
Convert all characters of a string to lower case.
Related functions:
upper() Convert all characters in a string to upper case.
wordcap() Capitalize the first letter of each word in a string.
Syntax:
lower(s)
Parameter:
|
s |
The string you want to convert to lower case |
Return value:
Character type
Option:
|
@q |
A quoted string won’t be converted |
Example:
Example 1: lower("ABCdef") Return "abcdef"
Example 2: lower("defABC") Return "defabc"
Example 3: lower@q("\'AD\'") Return "'AD'"
Description:
Get a string’s substring starting from the specified position and of the specified length.
Related functions:
left() Get a substring starting from the leftmost side of a source string.
right() Get a substring of a string ending at the rightmost side.
Syntax:
mid(s, start{, end})
Parameter:
|
s |
The source string from which you get the substring |
|
start |
The start position of the substring |
|
end |
The start position of the substring; by default, the substring’s length will be counted from the start position to the end of the source string |
Return value:
String type
Example:
Example 1: mid("abcde",1) Return abcde
Example 2: mid("abcde",1,2) Return ab
Example 3: mid("abcde",3) Return cde
Description:
Get the position of a substring starting from the specified position in its parent string, and return null if the substring cannot be found.
Syntax:
pos(s1, s2{, begin})
Parameter:
|
s1 |
The parent string where you want to search for a substring |
|
s2 |
Substring of interest |
|
begin |
The position from which the search starts; the default start position is1 |
Option:
|
@z |
Perform the search leftward starting from the position specified by parameter begin, while the search will be done rightward from that position by default |
Return value:
Integer type
Example:
Example 1: pos("abcdef","def") Return 4
Example 2: pos("abcdefdef","def",5) Return 7
Example 3: pos("abcdef","defa") Return null
Example 4: pos@z("abcdeffdef ","def",7) Return 4
Description:
Replace a specified substring of a source string.
Syntax:
replace( src,a,b)
Parameter:
|
src |
Source string |
|
a |
A substring of the source string |
|
b |
The string with which the specified substring will be replaced |
Return value:
A string after the replacement
Option:
|
@q |
A quoted specified string won’t be replaced |
Example:
Example 1: replace("abc'abc'def","a","China") Return "Chinabc'Chinabc'def"
Example 2: replace ("abc'abc'def","a","China") Return "Chinabc'Chinabc'def"
Example 3: replace@q ("abc'abc'def","a","China") Return "Chinabc'abc'def"
Description:
Get a substring of length n ending at the rightmost side of a string. If n<0, the substring’s length is the sum of source string’s length and the value of n.
Related functions:
left() Get a substring starting from the leftmost side of a string.
mid() Get a substring within a string.
Syntax:
right(s, n)
Parameter:
|
s |
Source string from which you get the substring |
|
n |
The length of the target substring |
Return value:
String type
Example:
Example 1: right("abced",2) Return "ed"
Example 2: right("abced",-2) Return "ced"
Description:
Delete escape characters, and double and single quotation marks in the outermost layer.
Syntax:
rmquote(exp)
Parameter:
|
exp |
An expression |
Return value:
String type
Example:
Example 1: rmquote(arg1) Return s'd'sdwewe; value of variable is "s'd'sd\nwewe"
Description:
Generate an empty string.
Related function: fill() Create a new string by concatenating strings together.
Syntax:
space(n)
Parameter:
|
n |
Length of the to-be-generated empty string |
Return value:
A string generated by concatenating spaces
Example:
Example 1: space(5) Return " "
Description:
Split a string into multiple substrings using the delimiter.
Syntax:
split( srcExp,sepExp)
Parameter:
|
srcExp |
A string expression to be split |
|
sepExp |
The delimiter expression |
Return value:
A list of substrings after the specified string is split
Option:
|
@q |
Parse delimiters within quotation marks and paratheses/brackets; by default, they are not parsed |
|
@a |
Retain blank strings on both sides of each substring; by default, remove those blank strings |
Example:
Example 1: split("ab;cd;ef;tg;tt",";")
Return array["ab","cd","ef","tg","tt"]
Example 2: split("ab;c'd;e'f;tg;tt",";")
Return array ["ab","c'd;e'f","tg","tt"] Do not parse delimiters within the quotation marks
Example 3: split("ab;c[d;e]f;tg;tt",";")
Return array ["ab","c[d;e]f","tg","tt"] Do not parse delimiters within the brackets
Example 4: split@q("ab;c'd;e'f;tg;tt",";")
Return array ["ab","c'd","e'f","tg","tt"] Parse delimiters within the quotation marks
Example 5: split@q("ab;c[d;e]f;tg;tt",";")
Return array ["ab","c[d","e]f","tg","tt"] Parse delimiters within the brackets
Example 6: split@a(" ab ,cd,ef, tg,tt ",",")
Return array [" ab ","cd","ef"," tg","tt "] Retain blank strings on both sides of each substring
Description:
Remove the blank characters from both ends of a string.
Syntax:
trim(s)
Parameter:
|
s |
Source string from which you want to remove blank characters on both sides |
Return value:
String type
Option:
|
@l |
Remove spaces to the left of the string, with the parameter being letter l |
|
@r |
Remove spaces to the right of the string; by default, remove spaces on both ends |
|
@a |
Remove all extra whitespaces; if there is one or continuous whitespaces within the string, retain only one whitespace; remove the whitespaces between a character and a word, but retain whitespaces within the quotation marks |
Example:
Example 1: trim(" abc ") Return "abc"
Example 2: trim(" a bc ") Return "a bc"
Example 3: trim@l(" def abc ") Return "def abc "
Example 4: trim@r(" abc def ") Return " abc def"
Example 5: trim@a("a bc") Return "a bc"
Example 6: trim@a("a\' bc\' ") Return "a' bc'"
Example 7: trim@a("abc !") Return "abc!"
Description:
Convert all characters in a string to upper case.
Related functions:
lower() Convert all characters in a string to lower case.
wordcap() Capitalize the first letter of each word in a string.
Syntax:
upper(s)
Parameter:
|
s |
Source string to be converted to upper case |
Return value:
String type
Option:
|
@q |
The quoted strings won’t be converted |
Example:
Example 1: upper("ABCdef") Return "ABCDEF"
Example 2: upper("abcDEF") Return "ABCDEF"
Example 3: upper@q("\'abCD\'") Return "'abCD'"
Description:
Encode a URL string.
Syntax:
urlencode(s, cs)
Parameter:
|
s |
A URL string to be encoded |
|
cs |
Character set |
Return value:
String type
Option:
|
@r |
Decode, which is the inverse operation of urlencode() function |
|
@f |
It means that the to-be-encoded string is a complete URL; with this option, the function splits the URL string into different parts and encode each part |
Example:
Example 1: urlencode ("哥哥","utf8") Return "%E5%93%A5%E5%93%A5"
Example 2: urlencode@r("%E5%93%A5%E5%93%A5","utf8") Return "哥哥"
Example 3: urlencode@f("http://localhost:6868/demo/测试/test.jpg","utf8")
Return " http://localhost:6868/demo/%E6%B5%8B%E8%AF%95/test.jpg"
Description:
Capitalize the first letter of each word in a string.
Related functions
upper() Convert all characters in a string to upper case.
lower() Convert all characters in a string to lower case.
Syntax:
wordcap(s)
Parameter:
|
s |
Source string for which you want to capitalize the first letter of each word |
Return value:
String type
Example:
Example 1: wordcap("I love my country") Return "I Love My Country"
Example 2: wordcap("she is beautiful") Return "She Is Beautiful"