I. Strings

1. Concatenation

(1) Concatenate two strings

(2) Concatenate string and any type

(3) Concatenate sequence members

(4) Concatenate sequence table members

2. Split

(1) split into character sequence

(2) split into word sequence

(3) split with separator

(4) split with regular expression

3. Parse

(1) parse numerical value

(2) parse any single value

(3) parse multiple values

(4) parse sequence table

(5) parse regular expression to match string

(6) parse using codes

4. Complex processing

(1) SQL analysis

(2) SQL translation

(3) JSON processing

(4) XML processing

(5) HTML analysis

II. Date time

1. Calculate the single value of date and time

2. Calculate date time sequence

Click to download the PDF file