Articles in this section

See more

How to Search for Terms in Text Analysis

  • Updated
Follow

Searches through text for a particular term and displays a table showing the cases that contain that search term. This is useful when you try to understand the context of a specific word or phrase in your text. The input text can be a Text variable, a character vector in an R Calculation Output, or the processed text from a variable created by How to Extract Keywords and Phrases from Text. If you use processed text to search, the table will display both the original text input as well as the processed text.

Requirements

Method - Create the search analysis

  1. From the Report tree, select + > Advanced Analysis > Text Analysis > Advanced > Search.
  2. Under Data > Input, select a Setup Text Analysis object, a Text variable, or a Calculation listing text.
  3. Enter a Search Term (in the example below, wine) and hit Enter. The output will display a table with results that include the search term. 

Worked example:
textAnalysisSearch.png
In the example above, we have first processed the text from a survey question that asked people the first thought that comes to mind about France, using Extract Keywords and Phrases from Text. Since the text has been pre-processed, the table shows both the original text and the results of the processing. If you use a text variable or character vector under Data > Input, then the result will instead be a single column containing the text only. The search term that is used is the word wine, and it appears in bold when it is identified in the processed text. 
ProcessedText.png

Extract processed text

To get an output that contains only the processed text (i.e., the right column of keywords above), take these steps:

  1. Click + in the Report pane, or from the toolbar while on a page, select Calculation 26UI_Calculation.png > Custom Code.
  2. Click on the page to add the calculation.
  3. In the Code 26UI_CodeEditor.png panel, paste the code below, where text.search is the name of your Text Search output: 
text.search$Processed.Text

Click Calculate.

Make the search widget interactive in View Mode

If you want viewers of your dashboard to be able to search text responses, you can create a Text Control and edit the R code of the Text Analysis - Search output to reference that instead of the field in the object inspector. To do so:

  1. First, create the Text Control. While on a Page, from the toolbar, click Control 26UI_Control.png > Text.
  2. Click on the Page to place your Text Control.
  3. Optional - in Properties 26UI_ObjectInspector.png, you can use the Tooltip or Placeholder fields to add in helping or default text.
  4. Now edit the Text Analysis - Search R code to reference the text control. Select the search output and access the R code via Properties 26UI_ObjectInspector.png> Attributes > Code.
  5. In the Code 26UI_CodeEditor.png panel, press Ctrl+F and search for formSearch in the code.
  6. Highlight formSearch and then click on the name that pops up on your Text Control to swap in the Text Control reference in the code.
  7. Now you can type in your search term into the Text Control for searching.

Formatting text data

The feature is built to search for a single variable/list of data, but sometimes you may have multiple variables you want to search at once. You can reformat your text into one variable/list to use in the tool. There are a couple of ways to do this, depending on what you need. 

To create a new variable in the data set that concatenates the text together

Create a new JavaScript text variable, and then in the Code 26UI_CodeEditor.png panel, paste and modify the following code:

//change textVar1, textVar2 etc to the Names of your text variables
//you can additionally change " - " below to whatever you want to use to separate the responses
textVar1 + " - " + textVar2 + " - " + textVar3

To stack the text variables together in an R Calculation

You can reformat your variables into a "long" format where you stack all of the text variable data on top of one another.

  1. Optional: If the text variables to search are in individual sets, you need to first combine them into a single Variable Set:
    • From the Data Sources tree, select the variables, right-click, and select Duplicate.
    • With the duplicates selected, right-click, and select Combine > As a Variable Set. The Structure of the new variable set should be recognized as a Text-Multi. 
  2. From the toolbar or + in the Report tree, go to Calculation 26UI_Calculation.png > Custom Code.
  3. If using the toolbar, click on the Page to position the output.

  4. In the Code 26UI_CodeEditor.png panel, paste in the following code and modify as described

    #specify the Text-Multi variable set to search
#put the label of the set within backticks below
textvar=`My Text Variable Set`

#make a vector
texts=unlist(textvar)

#remove names to make one column
names(texts) <- NULL

#show final text
texts
  5. Click Calculate.
  6. Use the output created above in the search output in Properties 26UI_ObjectInspector.png> Data > Input field.

Next

How to Extract Keywords and Phrases from Text

Related articles