Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


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