Filemaker TH325Z/A Fiche technique Page 175
- Page / 238
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Chapter 12
|
Text functions 175
Examples
LeftWords(“Plaid Canvas Suitcase”;2) returns Plaid Canvas.
LeftWords(Name;1) returns Sophie, when the Name field contains Sophie Tang.
Length
Format
Length(field)
Parameter
field - any text, number, date, time, timestamp, or container field, or any text expression
or numeric expression
Data type returned
number
Description
Returns the number of characters in field, including all spaces, numbers, and special
characters. For a container field, Length returns the total stored size of objects in bytes.
Examples
Length(“John”) returns 4.
Length(Description) returns 12 when the value in Description is Modem for PC.
Length(“M1” & Left(Product;5)) returns 7, when the Product field contains
Canvas Backpack.
Lower
Format
Lower(text)
Parameter
text - any text expression or text field
Data type returned
text
Description
Returns all letters in text as lowercase.
- FileMaker 1
- Contents 3
- Contents 5 5
- Logical functions 127 6
- Contents 7 7
- Text functions 161 8
- Contents 9 9
- Chapter 1 11
- Introduction 11
- Introduction 13 13
- H, I, J, K 14
- L, M, N, O 15
- V, W, X, Y, Z 16
- Chapter 2 17
- Aggregate functions 17
- Aggregate functions 19 19
- Aggregate functions 21 21
- Aggregate functions 23 23
- Variance 27
- VarianceP 28
- Chapter 3 31
- Date functions 31
- Date functions 33 33
- DayNameJ 34
- DayOfWeek 34
- DayOfYear 35
- MonthName 36
- MonthNameJ 36
- WeekOfYear 37
- WeekOfYearFiscal 37
- YearName 39
- Chapter 4 41
- Design functions 41
- DatabaseNames 43
- FieldBounds 43
- FieldComment 44
- FieldIDs 45
- FieldNames 45
- FieldRepetitions 46
- FieldStyle 47
- FieldType 48
- GetNextSerialValue 49
- LayoutIDs 49
- LayoutNames 50
- LayoutObjectNames 50
- RelationInfo 51
- ScriptIDs 52
- ScriptNames 53
- TableIDs 53
- TableNames 54
- ValueListIDs 54
- ValueListItems 55
- ValueListNames 55
- WindowNames 56
- Chapter 5 57
- External functions 57
- External 58
- Chapter 6 59
- Financial functions 59
- Chapter 7 63
- Get functions 63
- Get functions 65 65
- Get functions 67 67
- Get(AccountName) 68
- Get(ActiveFieldContents) 68
- Get(ActiveFieldName) 69
- Get(ActiveFieldTableName) 69
- Get(ActiveLayoutObjectName) 70
- Get(ActiveModifierKeys) 71
- Get(ActiveRepetitionNumber) 71
- Get(ActiveSelectionSize) 72
- Get(ActiveSelectionStart) 72
- Get(AllowAbortState) 73
- Get(AllowToolbarState) 73
- Get(ApplicationLanguage) 74
- Get(ApplicationVersion) 75
- Get(CurrentDate) 76
- Get(CurrentHostTimestamp) 76
- Get(CurrentTime) 77
- Get(CurrentTimestamp) 78
- Get(CustomMenuSetName) 78
- Get(DesktopPath) 79
- Get(DocumentsPath) 80
- Get(ErrorCaptureState) 80
- Get(ExtendedPrivileges) 81
- Get(FileMakerPath) 81
- Get(FileName) 82
- Get(FilePath) 82
- Get(FileSize) 83
- Get(FoundCount) 84
- Get(HighContrastColor) 84
- Get(HighContrastState) 85
- Get(HostIPAddress) 85
- Get(HostName) 86
- Get(LastError) 87
- Runtime errors 88
- Get functions 89 89
- Get functions 91 91
- Get(LastMessageChoice) 93
- Get(LastODBCError) 94
- Get(LayoutAccess) 94
- Get(LayoutCount) 95
- Get(LayoutName) 96
- Get(LayoutNumber) 96
- Get(LayoutTableName) 97
- Get(LayoutViewState) 97
- Get(MultiUserState) 98
- Get(NetworkProtocol) 99
- Get(PageNumber) 99
- Get(PortalRowNumber) 100
- Get(PreferencesPath) 100
- Get(PrinterName) 101
- Get(PrivilegeSetName) 102
- Get(RecordAccess) 102
- Get(RecordID) 103
- Get(RecordModificationCount) 104
- Get(RecordOpenCount) 105
- Get(RecordNumber) 105
- Get(RecordOpenState) 106
- Get(RequestCount) 107
- Get(RequestOmitState) 107
- Get(ScreenDepth) 108
- Get(ScreenHeight) 108
- Get(ScreenWidth) 109
- Get(ScriptName) 109
- Get(ScriptParameter) 110
- Get(ScriptResult) 111
- Get(SortState) 112
- Get(StatusAreaState) 112
- Get(SystemDrive) 113
- Get(SystemIPAddress) 114
- Get(SystemLanguage) 114
- Get(SystemNICAddress) 115
- Get(SystemPlatform) 115
- Get(SystemVersion) 116
- Get(TextRulerVisible) 116
- Get(TotalRecordCount) 117
- Get(UserCount) 117
- Get(UserName) 118
- Get(UseSystemFormatsState) 119
- Get(WindowContentHeight) 119
- Get(WindowContentWidth) 120
- Get(WindowDesktopHeight) 120
- Get(WindowDesktopWidth) 121
- Get(WindowHeight) 122
- Get(WindowLeft) 122
- Get(WindowMode) 123
- Get(WindowName) 123
- Get(WindowTop) 124
- Get(WindowVisible) 125
- Get(WindowWidth) 125
- Get(WindowZoomLevel) 126
- Chapter 8 127
- Logical functions 127
- Evaluate 129
- EvaluationError 131
- GetAsBoolean 131
- GetField 132
- GetLayoutObjectAttribute 133
- GetNthRecord 134
- Logical functions 135 135
- IsValidExpression 137
- Logical functions 139 139
- LookupNext 141
- 1 to 4 142
- Chapter 9 143
- Number functions 143
- Combination 145
- Factorial 146
- Number functions 147 147
- Ln number() 148
- SetPrecision 151
- Truncate 153
- Chapter 10 155
- Repeating functions 155
- GetRepetition 156
- Repeating functions 157 157
- Chapter 11 159
- Summary functions 159
- GetSummary 160
- Chapter 12 161
- Text functions 161
- Text functions 163 163
- FilterValues 164
- GetAsCSS 165
- GetAsDate 166
- GetAsNumber 166
- GetAsSVG 167
- GetAsText 168
- GetAsTime 168
- GetAsTimestamp 169
- GetAsURLEncoded 169
- GetValue 170
- Hiragana 171
- KanaHankaku 171
- KanaZenkaku 172
- KanjiNumeral 172
- Katakana 172
- LeftValues 173
- LeftWords 174
- Text functions 175 175
- MiddleValues 176
- MiddleWords 177
- NumToJText 178
- PatternCount 179
- Position 179
- Text functions 181 181
- RightValues 182
- RightWords 183
- RomanHankaku 184
- RomanZenkaku 184
- SerialIncrement 185
- Substitute 186
- Text functions 187 187
- ValueCount 189
- WordCount 189
- Chapter 13 191
- Text formatting functions 191
- TextColor 192
- TextColorRemove 193
- TextFont 194
- TextFontRemove 195
- TextFormatRemove 196
- TextSize 197
- TextSizeRemove 197
- TextStyleAdd 198
- TextStyleRemove 199
- Chapter 14 201
- Time functions 201
- Time functions 203 203
- Examples 204
- Chapter 15 205
- Timestamp functions 205
- Timestamp 206
- Chapter 16 207
- Trigonometric functions 207
- Appendix A 213
- Glossary 213
- Glossary 215 215
- Glossary 217 217
- Glossary 219 219
- Glossary 221 221
- Glossary 223 223
- Glossary 225 225
- Glossary 227 227
- Glossary 229 229
- Glossary 231 231
- Glossary 233 233
- Glossary 235 235
- W, X, Y, Z 237
Produits connexes et manuels pour Logiciel de base de données Filemaker TH325Z/A
(21 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.043 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels