Reformat tool (beta)

673d23dd68cf08627e90e16be103471a

Updated at February 20th, 2020

Protobi has a reformat tool that aides in the process of coding text verbatims into broader categories. Each element has a reformat page. At the top of the page the project name and the element key are displayed. 

The main components of the page are:

  • Values/ tags: The values and their corresponding tags
  • Codes: Every tag that is added to the element will show up here
  • Search bar: Look up key words to limit the values that appear
  • Toolbar: Allows you to save, select values, add tags, etc...

How to access

To get to an element's reformat page, press on the heading of the element you want to recode. It will turn blue to indicated it's selected. Then, from the "Advanced" button on the toolbar choose "Recode (BETA)."

Values/tags

Under the search bar, values from the element appear on the left, and each tag that is assigned to the value is on the right. 

  • Press on value(s) to select (yellow highlight)/ press again to deselect (white)
  • Press Esc on your keyboard as another way to deselect values
  • Press "+": brings up the add tag dialog 
    • You can choose an existing tag or create a new one. Press ok.
  • Press a tag: limits the view to only values that have the tag
    • Press the tag "none"  to see all uncoded values
  • Press "x": removes tag from value

Codes

The codes box on the far right of the page contains every tag that appears in the element. 

  • Press a tag: limits the view to only values that have the tag
  • Press "x": deletes ALL instances of the tag 

Search bar

The search bar allows you to limit the view to values that mention a key word. Search "difficult," and only values that contain the word will appear in the view. 

Toolbar

Save (S)

Press (or use keyboard shortcut: S) to save your work.


Toggle (f)

Press to switch between raw and formatted values. 

The toggle button is particularly helpful for open-ends where respondents answered in a foreign language: 

After translating the element, on the reformat page the toggle button allows you to switch the view between Chinese (raw) and English (formatted) values.


Select all (e)

Press to select all the values in the view. 

Below, we've used the button to select all values that mention "difficult." You can then add tags to many values at once. Press again to deselect all.


Add tag (t)

Press to add tag to selected values.

This button is an alternative to pressing the "+" sign next to values. Pressing will bring up the add tag dialog. You can choose an existing tag or create a new one. Press ok. 


Download

CSV (E C) or XLSX (E X)

You can download the coded values in CSV or XLSX format. Below we see the downloaded Excel for an element (Q7_chinese). 

  • Column A: raw values
  • Column B: formatted values
    • If values were not formatted, the raw values will also be under fmt
  • Column C: the tags assigned to each value


Upload

CSV or XLSX

If you prefer to do your coding in Excel, you can do so and upload the file. 

In order for this to work, use the column names seen in the downloaded file: value, fmt, (element key). If you do not have fmt (formatted) values, delete the column.


See related

Code text verbatims using the "Recode" dialog from the context menu.

Was this article helpful?