This chapter lists code examples about handling strings, including Generate a fixed-length string, Search for and replacstring
In esProc, strings are not merely a data type; they can be used as macros or string constants to construct expressions, string,eval
Description: Convert a string or a numeric value to a big decimal number. Syntax: decimal(stringExp) decimal(numberExp) string,numeric value,big decimal number
Description: Convert all characters of a string to lower case. Syntax: lower(s) Note: The function converts all charactestring,convert to lower case
Description: Get a string’s MD5 signature. Syntax: Md5(s) Note: The function gets string s’s MD5 signature. MD5 is a widstring, md5 signature
Description: Get a substring of a string. Syntax: mid(s,n{,l}) Note: The function gets a substring of the length of l frstring, substring
Description: Convert a string to a real number. Syntax: number (stringExp,format) Note: The function parses string stristring, convert, number
Description: Get a substring of a string ending at the rightmost side. Syntax: right(s,n) Note: The function gets a subsstring,right,substring
Description: Find a substring and return the string after the substring. Syntax: substr(s1,s2) Note: The function finds string,substring
Description: Remove the blank characters from both ends of a string. Syntax: trim(s) Note: The function removes the blanremove,string,blank characters