Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    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.

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


List.BestMatch   -   List.CrossProduct

Feedback: Report problem or ask question.




Links
MBS Xojo PDF Plugins