Monkeybread Software - MBS FileMaker Plugin: QuickList.CSVSplit

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: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

QuickList.CSVSplit

Splits CSV text.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
List	7.4	Yes	Yes	Yes	Yes	Yes

MBS( "QuickList.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

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 QuickList reference number 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.

Examples

Try with 3 values:

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

Blog Entries

Release notes

Version 8.5
- Added delimiter parameter for List.CSVSplit, QuickList.CSVSplit and FM.InsertRecordCSV.
Version 7.4
- Added CSV functions: FM.InsertRecordCSV, List.CSVSplit and QuickList.CSVSplit.

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

QuickList.BestMatch - QuickList.Clear

Feedback: Report problem or ask question.