DataCacheToString (7.7)

Returns a string of values from the a column of specified DataCache.

Usage

@DCString(<DataCacheName>, [ColumnIndex], [StringDelimiter], [StringDelimiterEscapeChar], [ValueDelimiter], [SortOrder])

Argument Name Description
ColumnIndex Optional (default is "1"); The column number to build the string from.
DataCacheName The name of the DataCache.
SortOrder Comma delimited list of columns to sort the DataCache by. When specifying more than one column SortOrder must be in quotes. Example: Col1 Example: Col1, Col3 Example: "Col2 DESC, Col1 ASC"
StringDelimiter Optional (default is none); The character to use to wrap each value in the resulting string, typically a single-quote or double-quote.
StringDelimiterEscapeChar Optional (default is StringDelimiter); Each occurrence of StringDelimiter within a string will be prepended with the StringDelimiterEscapeChar.
ValueDelimiter Optional (default is ","); The character (or string) to use to separate each value.