SplitTextInColumns
SpiltTextinColumns Function
Splits text by specified number of characters into multiple columns.
Syntax
SplitTextInColumns (vector KeyColumn, vector StringValue, scalar Number of characters, scalar Number of columns, scalar Maintain word boundary, scalar Stuff remaining in last column)
Arguments
| Argument | Description |
|---|---|
vector KeyColumn | Key column |
scalar StringValue | Input data that needs to be split |
Scalar Number of characters | Maximum number of characters in each new column |
Scalar Number of columns | Number of columns to be split |
Scalar Maintain word boundary | Do not split the word in between |
Stuff remaining in last column | Display remaining charaters in the last column |
Examples:
SplitTextInColumns(array(1,2,3), array("Nancy Davolio Sales Representative", "Andrew Fuller Vice President, Sales", "Janet Leverling Sales Rep"), 7, 3, true, true)
Splits the text in the second column into 3 columns and the maximum number of characters in each new column is 7. Do not split the word in between and the last column displays the remaining characters.