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: 7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  

List.CSVSplit

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 )

Parameters

Parameter Description Example value
Text The CSV text.

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.

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

Created 21st September 2017, last changed 10th January 2018


List.BestMatch   -   List.CountValues

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins