String Functions

Read(2434) Label: string function,

  esProc offers string functions that handle string values.

Ø  A.export()

Convert a sequence into a string.

Ø  A.regex()

Match each member of a string sequence with a regular expression

Ø  A.concat()

Concatenate members of a sequence with the delimiter and return result as a string

Ø  S.import()

Retrieve contents from a string as records and return them as a table sequence

Ø  asc()

Obtain the Unicode value of a character at the specified position in a string

Ø  base64()

Base64-encode the given data 

Ø  blob()

Convert a blob object into an integer sequence, or vice versa

Ø  cellname()

Return an Excel cell name according to specific row and column

Ø  char()

Get corresponding characters according to the given Unicode or ASCII code

Ø  charencode()

Generate the binary value of a string according to the character set the latter uses, or vice versa

Ø  chn()

Write a number with the Chinese numerals

Ø  concat()

Concatenate parameters into a string

Ø  concat(x;d)

Use a delimiter to concatenate values of an aggregation field

Ø  fill()

Concatenate multiple strings to create a new string

Ø  format()

Generate a formatted string in Java

Ø  htmlparse()

Get text data under a specified tag in an html file

Ø  json()

Parse a string, a record, a sequence or a table sequence in JSON format

Ø  isalpha()

Check if a string is composed of letters

Ø  isdigit()

Check if a string is composed of numbers

Ø  islower()

Check if a string is composed of lower case letters

Ø  isupper()

Check if a string is composed of upper case letters

Ø  left()

Get a substring starting from the leftmost side of a source string

Ø  len()

Compute the length of a string

Ø  like()

Find if a string matches the format string

Ø  lower()

Convert all characters of a string to lower case

Ø  md5()

Return a string’s MD5 signature

Ø  mid()

Get a substring of a string

Ø  number()

Convert a string to the corresponding real number

Ø  pad()

Pad a string to a certain length by adding another string on the left

Ø  parse()

Parse a string into the corresponding data type

Ø  pos()

Get the position of a substring in its parent string

Ø  rands()

Get a random string

Ø  replace()

Replace a specified substring of a source string

Ø  right()

Get the substring starting from the rightmost side of a source string

Ø  s.regex()

Match a string with a regular expression

Ø  s.sbs()

Get multiple substrings from a string to form a new string

Ø  s.split()

Split a string into a sequence by the delimiter

Ø  s.words()

Extract the English words from a string

Ø  sql.sqlparse()

Split a SQL query into a sequence

Ø  sql.sqltranslate()

Translate standard SQL functions into functions a specified database defines

Ø  substr()

Find a substring and return the string after the substring

Ø  string()

Convert the data type of an object to the string data type

Ø  trim()

Remove the blank characters on both ends of a string

Ø  upper()

Convert all characters in a string to upper case

Ø  urlencode()

Encode a URL string

Ø  xml()

Parse a string/a table sequence in the XML format

Ø  xs.property()

Read property values from node strings