Skip to main content
Skip table of contents

Trim labels directly in a crosstab

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

trim labels both.png
  • 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

Trim labels on DVI.gif

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.