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: 11.2   11.3   11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5    Statistic    FMM    Blog  

List.CSVSplit

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

Parameters

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

Result

Returns list or error.

Description

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.

Examples

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

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


List.BestMatch - List.CountValues

Feedback: Report problem or ask question.


Start Chat