Filemaker TH325Z/A Datasheet Page 177
- Page / 238
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Chapter 12
|
Text functions 177
Important See chapter 4, “Design functions” for information about literal text parameters.
Data type returned
text
Description
Returns a text result containing the specified numberOfValues in text, starting with
startingValue.
Values are text items separated by carriage returns. A value can be empty, a single
character, a word, a sentence or a paragraph. When you press Return you start creating
a new value. The last value will be recognized with or without a carriage return.
Each value that is returned ends with a carriage return, allowing lists to be easily
concatenated.
Examples
MiddleValues(“Plaid¶Canvas¶Suitcase”;2;1) returns
Canvas
MiddleValues(list;2;2) returns
Bill
John
when the list field contains
Sophie
Bill
John
MiddleWords
Format
MiddleWords(text;startingWord;numberOfWords)
Parameters
text - any text expression or text field
startingWord - any numeric expression or field containing a number
numberOfWords - any numeric expression or field containing a number
Data type returned
text
- 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
Related products and manuals for Database software Filemaker TH325Z/A
(21 pages)© 2020, manymanuals.com. All rights reserved. | 0.033 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals