Extract common text

Extract common title text to organize view of similar questions

38d87d9852a66eea29da00ae16511664

Updated at October 15th, 2019

Many surveys have groups of related questions, like "Check all that apply..." or "How many of each...."  When exporting the data to SPSS, survey engines will combine the text for each question item with the labels for the parent group.

Protobi has advanced features to extract common text from multiple elements.

Example

For instance, in the survey below, there are several questions q5a, q5b, q5c, q5d, each of which contain common title text  (e.g., "In your opinion, in AMERICA, how much conflict is there between... - ") as well as text specific to each item (e.g., "Young people and older people"). 

Extract common text from titles

Select the parent group by pressing its header, and from the "Advanced" menu choose "Extract common text" (shortcut: press Shift+X Shift+T in sequence). 

This will bring up a dialog:

Protobi finds the longest strings that appear in all of the questions, and presents these as suggested options.  You can also manually enter a specific string in the input box.   

Protobi will append the text to the title of the parent group and remove the matching string from each child if found.

For this example, repeating this process twice results in the following:  


With the common text removed, the short labels appear nicely when in compact display (please see "Compact to..." tutorial):

Was this article helpful?