BizInt Cookbook of Reports & Visualizations

www.bizint.com/Cookbook | © 2023 BizInt Solutions, Inc., 06 /2023 Cookbook of Reports & Visualizations

Technique: Extracting Keywords You may find yourself wanting to extract a set of keywords from a field. For example, you might want to visualize Endpoint Classifications in search results from Citeline TrialTrove. TrialTrove provides this information as part of the “Study Design” column, in one of two different formats. This Technique shows how to extract a set of keywords from a field in VP-SCE using the My Keywords feature.

FIGURE 1. THE MY KEYWORDS PANEL

MANAGE KEYWORDS MENU

KEYWORDS EXTRACTED USING REGULAR EXPRESSIONS

FIGURE 2. KEYWORDS EXTRACTED INTO NEW COLUMNS

36 PAGE