Handling of strings and date time

 

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