I. text decoding and search processing:
1. @ left @ leftback @ right @ rightback @ middle @ middleback @ word
SSN = "123-45-6789"
@ Left (SSN, 3) --------- 123
@ Leftback (SSN, 8) -------- 123
@ Right (SSN, 4) --------- 6789
@ Rightback (SSN, 7) ------- 6789
@ Middle (SSN, 4, 2) ------- 45
@ Middleback (SSN, 8, 2) ------- 45
@ Word (SSN, "-", 3) ------- 6789 'the third part separated by-delimiter
2. randomstring: @ text (@ INTEGER (998 * @ random + 1 ))
3. Determine whether the struct string contains characters: @ contains (string, searchstring)
Ii. List Processing)
1. Addition and multiplication of the list:
List1: "A": "B": "C" list2: "X": "Y ":""
List1 + list2 = "ax": "by": "C" list1 * + list2 = "ax": "ay": "Bx": "by": "CX ": "Cy"
2. Use the Data Group operation list (values can be referenced and cannot be set ):
Firstvalue: = list1 [1]
3. Comparison List Value:
@ Count (list1) returns the number of strings in the list. When the string is 0, 1 is returned.
@ Elements (list1) returns the number of strings in the list. When the string is 0, 0 is returned.
@ Member (list1, "B") returns Location 2
@ Ismember/@ isnotmember
@ Compare (list1: list2) returns 1, 0,-1
@ Keywords (list1: list2) returns the value of list2 in list1.
4. Values in the worker list:
@ Unique (list1: list2) merges two lists. Multiple duplicate values are combined into one
@ Sort
@ Subset (list1: Number): obtains the value of the sequence specified by number.
@ Replace (list1: value1: replacevalue) Replace the values in the lifecycle list.
@ Transform (list1: "X": @ lowercase (x) format the list, and X indicates the amount of time needed.
5. Values in the worker list:
@ Explode ("Red Blue Black"; "") splits the string into spaces as a list
@ Inplode (list1; ",") to combine and list values as strings "A, B, C"
@ Explode (date) 2005-3-18-2005-3-22 will be divided into five dates instead of two
Iii. function data:
1. Tracking processing data:
@ For (N: = 1; n <= number; N: = n + 1; statements)
@ While (n <number; statements; N: = n + 1)
@ Dowhile (statements; N: = n + 1; n <= Number) at least once
4. Processing:
1. @ statusbar refers to the information about the Development Environment
2. @ iserror @ iferror @ return
3. Use the dig command to warn you: @ prompt @ dialogbox
V. layout region:
Supports plain text, domain, sliced, and sliced by category, and only applies to the Notes client (not supported by the Web)
Vi. Design planner:
1. dingyi background Tablets
2. Design branch Metric: You can use the internal sequence and file name marker, multiple metric indicators can be displayed in a digital format (only the same metric item can be set (custom or custom metric item ))
3. Hidden columns (directly hidden or using formulas)
4. Set the color to RGB or "0000ff" in the watermark, and the value of the fixed watermark indicates the color of the watermark.
5. to retrieve the value of a column, You must retrieve its domain name rather than the column name.
6. Use of embedded metadata
7. embed the scanner
8. Functions of saveoptions reserved fields (1. Saved by using the scheme; 0. canceled by using the Scheme)
VII. Application of similar tables (CSS)
8. tips:
When you add $ keepprivate = "1" to a file, there is a restriction on disabling upload, upload, and printing.