![1PNG]()
![2PNG]()
I. Strings
![3PNG]()
1. Concatenation
(1) Concatenate two strings
![4PNG]()
![5PNG]()
(2) Concatenate string and any type
![6PNG]()
![7PNG]()
(3) Concatenate sequence members
![8PNG]()
![9PNG]()
![10PNG]()
![11PNG]()
(4) Concatenate sequence table members
![12PNG]()
![13PNG]()
2. Split
(1) split into character sequence
![14PNG]()
![15PNG]()
(2) split into word sequence
![16PNG]()
![17PNG]()
(3) split with separator
![18PNG]()
![19PNG]()
![20PNG]()
![21PNG]()
![22PNG]()
![23PNG]()
(4) split with regular expression
![24PNG]()
![25PNG]()
3. Parse
(1) parse numerical value
![26PNG]()
![27PNG]()
![28PNG]()
![29PNG]()
(2) parse any single value
![30PNG]()
![31PNG]()
(3) parse multiple values
![32PNG]()
![33PNG]()
(4) parse sequence table
![34PNG]()
![35PNG]()
(5) parse regular expression to match string
![36PNG]()
![37PNG]()
![38PNG]()
![39PNG]()
(6) parse using codes
![40PNG]()
![41PNG]()
4. Complex processing
(1) SQL analysis
![42PNG]()
![43PNG]()
(2) SQL translation
![44PNG]()
![45PNG]()
![46PNG]()
(3) JSON processing
![47PNG]()
![48PNG]()
(4) XML processing
![49PNG]()
![50PNG]()
![51PNG]()
![52PNG]()
![53PNG]()
![54PNG]()
![55PNG]()
(5) HTML analysis
![56PNG]()
![57PNG]()
![58PNG]()
![59PNG]()
II. Date time
![60PNG]()
1. Calculate the single value of date and time
![61PNG]()
![62PNG]()
![63PNG]()
![64PNG]()
![65PNG]()
![66PNG]()
![67PNG]()
![68PNG]()
![69PNG]()
![70PNG]()
![71PNG]()
![72PNG]()
![73PNG]()
![74PNG]()
![75PNG]()
![76PNG]()
2. Calculate date time sequence
![77PNG]()
![78PNG]()
![79PNG]()
![80PNG]()
![81PNG]()
![82PNG]()
![83PNG]()
Click to download the PDF file