![]() As a result, SortValues and UniqueValues (and indeed all the other new FileMaker 16 text parsing functions) are not supported with Runtimes and will return “?” if evaluated within a Runtime application. has deprecated the ability to create Runtime versions of FileMaker databases. With the release of FileMaker 14, FileMaker Inc. the values in the result will not be sorted or otherwise shuffled around.įor example: UniqueValues ( “B¶a¶Z¶b♪¶z” ) = “B¶a¶Z¶”. UniqueValues will retain the original order of the list, keeping the first value encountered i.e. But if you want to achieve case sensitivity, you can use the “Unicode_Raw” locale.įor example: UniqueValues ( “aaa♪AA” ) = “aaa¶”, but UniqueValues ( “aaa♪AA” 1 “Unicode_Raw” ) = “aaa♪AA¶”. For text values, this means case insensitivity for most locales. To determine if two values are equivalent, FileMaker uses the indexing definition of what a duplicate is. The UniqueValues function removes duplicates from a list of values based on the specified data type and locale.įor the data type and locale parameters, the same considerations apply as with the SortValues function. These two functions are SortValues and UniqueValues.įileMaker developers have had to make due with custom functions to do the job of these two, but now we can make use of native functions instead. However, two of them are more general-purpose and have been a long time coming. Many of the text functions are targeted exclusively at working with JSON. The primary motivation for including these new functions was to support interactions with REST APIs. FileMaker 16 includes a host of new functions for parsing and manipulating text and binary data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |