Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.2   8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4   9.5    Statistic  


Splits CSV text.

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


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


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.


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

Blog Entries

Release notes

Created 21st September 2017, last changed 22nd October 2018

List.BestMatch   -   List.CountValues

Feedback: Report problem or ask question.

MBS Xojo Plugins