Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  


Splits CSV text.

Component Version macOS Windows Linux Server iOS SDK
List 7.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.CSVSplit"; Text { ; Delimiter } )   More


Parameter Description Example Flags
Text The CSV text. "Hello;World"
Delimiter Available in MBS FileMaker Plugin 8.5 or newer.
The delimiter to use.
If empty, we auto detect it.
";" Optional


Returns list or error.


Splits CSV text.
Plugin automatically detects if comma or semicolon is used.
Returns list with all values.

Version 8 can detect tab character, too.
Please note that the parsing can handle multi line values, but that causes the list to have multiple entries for the value. Use Matrix.CSVSplit or QuickList.CSVSplit to handle that better as those can hold multi line values.


Split with one value:

MBS("List.CSVSplit"; "hello")

Split with three values:

MBS("List.CSVSplit"; "\"hello\";\"test\";\"CSV\"")

Split with 3 rows and 3 values:

MBS("List.CSVSplit"; "\"hello1\";\"test\";\"CSV\"¶\"hello2\";\"test\";\"CSV\"¶\"hello3\";\"test\";\"CSV\"")

See also

Release notes

Blog Entries

This function checks for a license.

Created 21st September 2017, last changed 15th July 2022

List.BestMatch - List.CountValues

💬 Ask a question or report a problem