Desktop User Guides > Professional > Table scripting > Working with profile tables > Formatting profile tables
 
Formatting profile tables
Sample script file: ProfileTables.mrs
This example script is based on the Household sample data set. See Running the sample table scripts for more information.
You can format the content of the cells in the profile table in various ways. For example, you can restrict the number of characters displayed using the FormatExpression property of the CellItem object. This is useful when you have open-ended responses that contain very long text responses to questions. For example, the following script restricts the size of responses so that only the first 50 characters are displayed:
TableDoc.ProfileDefault.CellItems[0].FormatExpression = "Left(CText(Value), 50)"
For more information, see:
ICellItem_FormatExpression
See also
Working with profile tables