The trimming function allows you to shorten labels in a crosstab in bulk rather than edit each one manually.
Selected labels must have similar/matching words or characters to be trimmed in bulk.
To make trimming
-
Right-click on the labels and select the option ‘Trim all labels'. If you want to trim only a few labels, pick them and select ‘Trim labels of selected’ from the menu
-
Select whether to trim the prefix or suffix, depending on which part is common across all targeted labels. DataTile automatically highlights this common part by default;
-
Alternatively, you can select what part to trim manually;
-
Click OK
Note! Trimming in crosstab affect labels only in a particular query. If you want to edit labels in a codebook, you should use the trim function in Meta-Editor.