Functions Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Aggregate functions
- Chapter 3 Date functions
- Chapter 4 Design functions
- Chapter 5 External functions
- Chapter 6 Financial functions
- Chapter 7 Get functions
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostIPAddress)
- Get(HostName)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Chapter 8 Logical functions
- Chapter 9 Number functions
- Chapter 10 Repeating functions
- Chapter 11 Summary functions
- Chapter 12 Text functions
- Exact
- Filter
- FilterValues
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Chapter 13 Text formatting functions
- Chapter 14 Time functions
- Chapter 15 Timestamp functions
- Chapter 16 Trigonometric functions
- Appendix A Glossary
Katakana, page 168 Zenkaku Katakana converted from Hiragana.
Left, page 168 The specified number of characters in the text, counting from the left.
LeftValues, page
169
The specified number of values in the text, counting from the left.
LeftWords, page
170
The specified number of words in the text, counting from the left.
Length, page 170 The number of characters in the specified text, including all spaces, numbers, and
special characters.
Lower, page 171 All letters in the specified text as lowercase.
Middle, page 171 The specified number of characters in the text, starting at a specified character
position.
MiddleValues, page
172
The specified number of values in the text, starting with a specified value.
MiddleWords, page
173
The specified number of words in the text, starting with a specified word.
NumToJText, page
173
Roman numbers converted from Japanese text.
PatternCount, page
174
The number of occurrences of a search string in the specified text.
Position, page 175 The specified occurrence of a search string, starting from a specified position.
Proper, page 175 The first letter of each word in the specified text as uppercase, and all other letters
as lowercase.
Replace, page 176 A new string of characters consisting of the specified text as modified by the
specified replacement text.
Right, page 177 The specified number of characters in the text, counting from the right.
RightValues, page
177
The specified number of values in the text, counting from the right.
RightWords, page
178
The specified number of words in the text, counting from the right.
RomanHankaku,
page 179
Hankaku (alphanumeric & symbols) converted from Zenkaku (alphanumeric &
symbols).
RomanZenkaku,
page 179
Zenkaku (alphanumeric & symbols) converted from Hankaku (alphanumeric &
symbols).
SerialIncrement,
page 180
The combined text and numbers in a specified value, with the numbers
incremented by the specified amount.
Substitute, page 180 A text string with every occurrence of a specified search string in the text replaced
by a specified replacement string.
Trim, page 181 Text stripped of all leading and trailing spaces.
TrimAll, page 182 Text with full width spaces between non-Roman and Roman characters removed.
Upper, page 183 All letters in the specified text as uppercase.
ValueCount, page
184
A count of the total number of values in the specified text.
WordCount, page
184
A count of the total number of words in the specified text.
This function Returns