Functions Reference
Table Of Contents
- Contents
- About functions
- Functions reference (alphabetical list)
- Aggregate functions
- Container functions
- Date functions
- Design functions
- External functions
- Financial functions
- Get functions
- Get(AccountExtendedPrivileges)
- Get(AccountName)
- Get(AccountPrivilegeSetName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActivePortalRowNumber)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowFormattingBarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionState)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(ErrorCaptureState)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- Get(InstalledFMPlugins)
- 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(PersistentID)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(QuickFindText)
- 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(TemporaryPath)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(TriggerCurrentTabPanel)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetTabPanel)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(UUID)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowStyle)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Logical functions
- Mobile functions
- Number functions
- Repeating functions
- Summary functions
- Text functions
- Char
- Code
- Exact
- Filter
- FilterValues
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Text formatting functions
- Time functions
- Timestamp functions
- Trigonometric functions
FILEMAKER FUNCTIONS REFERENCE 207
Text functions
Text functions can be used to analyze, rearrange, extract, and build text strings. For example, you
could use the
MiddleWords function to extract specific words from supplied text.
Text functions operate on these parameters:
• fields of type text
• text constants (in quotation marks)
• expressions having a text result
Click a function name for details.
This function Returns
Char Returns the characters for the Unicode code points in the number.
Code Returns the Unicode code points for the characters in the text. If zero characters
are in the text, returns 0.
Exact 1 (True) for an exact match, or 0 (False) for a mismatch between two text strings
or container fields.
Filter Only the specified characters, in the order that they were originally entered in the
text.
FilterValues Only the specified values, in the order that they were originally entered in the text.
GetAsCSS The specified text, converted to the CSS (Cascading Style Sheets) format.
GetAsDate Dates in the specified text as field type date, for use in formulas involving dates or
date functions.
GetAsNumber Numbers in the specified text as field type number, for use with formulas involving
numbers or numeric functions.
GetAsSVG The specified text, converted to the SVG (Scalable Vector Graphics) format.
GetAsText The specified number, date, time or timestamp as field type text, for use with
formulas involving text or text functions.
GetAsTime Times or timestamps in the specified text as field type time, for use with formulas
involving the time or timestamp functions.
GetAsTimestamp The specified data as field type timestamp, for use with formulas involving
timestamps.
GetAsURLEncoded The specified text, converted with URL (Uniform Resource Locators) encoding.
GetValue A specific value from a list of values.
Hiragana Hiragana converted from Katakana (Hankaku and Zenkaku).
KanaHankaku Hankaku Katakana converted from Zenkaku Katakana.
KanaZenkaku Zenkaku Katakana converted from Hankaku Katakana.
KanjiNumeral Kanji numerals converted from Arabic numerals.
Katakana Zenkaku Katakana converted from Hiragana.
Left The specified number of characters in the text, counting from the left.
LeftValues The specified number of values in the text, counting from the left.
LeftWords The specified number of words in the text, counting from the left.
Length The number of characters in the specified text, including all spaces, numbers, and
special characters.