Skip to main content
All CollectionsCrosstab and Data AnalysisTips
Trim labels directly in a crosstab
Trim labels directly in a crosstab

Bulk labels editing in crosstab

Updated over a week ago

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

Trimming labels in bulk
  • 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

Trimming labels in bulk

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.

Did this answer your question?