Returns a string based on a Table where each line of text in the string represents a single row.
SppGetTextFromTable([Table Array],[Column Delimiter],[Row Delimiter])
Where:
Table Array is a Table Array (such as the data in a standard table, or the result of a QueryDataValues function).
Column Delimiter is the delimiter used between values in the same row different column. For example a comma (,) or tab character (for tab use the Char(9) function).
Row Delimiter is the delimiter used between values in different rows. For example a comma (,) or new line character (for new line use the NewLine() function).
| Rule | Result | Meaning |
|---|---|---|
| SppGetTextFromTable(DwLookupProducts,"&","|") | ID&Name&Value&Rate|1&Product A&24.99&1.50|2&Product B&13.00&8.70|3&Product C&8200.00&10.60|4&Product D&123.00&4.80|5&Product E&3141.59&2.32 | This is the returned text string with the column and row delimiters replaced. |
| ID | Name | Value | Rate |
|---|---|---|---|
| 1 | Product A | 24.99 | 1.50 |
| 2 | Product B | 13.00 | 8.70 |
| 3 | Product C | 8200.00 | 10.60 |
| 4 | Product D | 123.00 | 4.80 |
| 5 | Product E | 3141.59 | 2.32 |