DriveWorks Pro 15: SppGetTextFromTable [send feedback...]

SppGetTextFromTable

Returns a string based on a table where each line of text in the string represents a single row.

Syntax

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).

Examples

RuleMeaning
SppGetTextFromTable(DwLookupCost,Char(9),NewLine())Will return a formatted string from the Cost Lookup table.
SppGetTextFromTable(DWGroupTableCustomers,",",NewLine())Will return a formatted string from the Customers Group table.

Table of Contents