Home Search

DriveWorks Pro 21
SppGetTableFromText

Send Feedback

SppGetTableFromText

Returns a Table containing a specified number of data rows from an existing text string, separating on commas and new lines.

If you have a Text string with a different character separating the data than a comma use the Column Separator overload property to tell the Function which character separates the columns.

Syntax

SppGetTableFromText([Text String],[Column Separator])

Where:

Text String is a text string separated by commas and new lines.

Column Separator is the character that will be used to separate the columns of data in the Text (This is an optional property).

Example

RuleResultMeaning
SppGetTableFromText("Company,Address"&NewLine()&"DriveWorks Ltd,Cheshire"){"Company","Address";"DriveWorks Ltd","Cheshire"}Will return the text string as a Table Array.

Example Result Shown As A Table

CompanyAddress
DriveWorks LtdCheshire

Example Using Pipebars (|)

RuleResultMeaning
SppGetTableFromText("Company|Address"&NewLine()&"DriveWorks Ltd|Cheshire","|"){"Company","Address";"DriveWorks Ltd","Cheshire"}Will return the text string as a Table Array.

Example Result Shown As A Table

CompanyAddress
DriveWorks LtdCheshire