Matrix1 Utility Plug-ins

SPLIT CSV STRING


Syntax

SPLIT CSV STRING Source String
SPLIT CSV STRING Source String, Separator
SPLIT CSV STRING Source String, Separator, Quote

Description

This command accepts Excel-format CSV strings and splits the fields into words.

The following rules are used:
- Fields are separated with commas.
- Leading and trailing space-characters adjacent to comma field separators are removed.
- A Field can be delimited with double-quote characters.
- A comma is ignored within a delimited field.
- Two consecutive double-quotes within a delimited field indicate a single double-quote.

The second and third versions of this command operate in the same way, but allow you to specify alternatives to the comma and quote characters when splitting the string.

Go back to ...

Matrix1Util_16 Commands Menu
Matrix1 Utils Main Index
Matrix1 Utils Command List
Commands Menu
Main Menu

Copyright © Ian Mold - Matrix1 Software 2006 - 2011