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.
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).
| Rule | Result | Meaning |
|---|---|---|
| SppGetTableFromText("Company,Address"&NewLine()&"DriveWorks Ltd,Cheshire") | {"Company","Address";"DriveWorks Ltd","Cheshire"} | Will return the text string as a Table Array. |
| Company | Address |
|---|---|
| DriveWorks Ltd | Cheshire |
| Rule | Result | Meaning |
|---|---|---|
| SppGetTableFromText("Company|Address"&NewLine()&"DriveWorks Ltd|Cheshire","|") | {"Company","Address";"DriveWorks Ltd","Cheshire"} | Will return the text string as a Table Array. |
| Company | Address |
|---|---|
| DriveWorks Ltd | Cheshire |