Answered By: Mallory Stark
Last Updated: Aug 03, 2015     Views: 547

Factiva allows you to construct advanced search queries; the following table provides a guide to Factiva's search commands.

Connector

Explanation

and

technology spending and canada finds items containing the words "technology spending" as well as the word "canada"

or

merger or acquisition finds items containing either "merger" or "acquisition"

not

software not spreadsheets finds items containing the word “software,” but excludes those containing the word “spreadsheets”

() Parentheses or [] Brackets

select releases and (university or instruction, or courses) finds items containing the term “select releases” and one of the terms “university,” “instruction,” or “courses”

atleastn

atleast5 microsoft will return items with at least five mentions of Microsoft

Note: n is any number between 1 and 50. Atleast works only in Search: Free-Text/Indexing, and not in Track.

same

vodafone same telecommunications finds items containing "vodafone" in the same paragraph as "telecommunications"

adjn

w/n

world cup adj5 rugby and world cup w/5 rugby find items containing "World Cup" within 5 words of "rugby" in the order entered (“rugby” must come after “world cup”).

Note: n is any number from 1 to 10. A value for n must be specified for w/n but not adjn.

nearn

/Nn/

carrefour near5 retail sales and carrefour /N5/ retail sales  find items with the word "carrefour" within 5 words of "retail sales" in any order (“carrefour" may come before or after “retail sales”).

Note: n is any number from 1 to 500. A value for n must be specified for /Nn/ but not nearn.

/Fn/

toyota/F50/  finds items with the word "toyota" in the first 50 words of the article.
Note: n is any number from 1 to 500. /Fn/ works only in Search: Free-Text/Indexing, and not in Track.

$n 

earn$4  finds items containing words with the root "earn" that have up to 4 letters after the root (e.g. “earnings,” “earns,” “earned,” not “earnestly”).
Note: n is any number from 1 to 9. At least 3 characters must be typed before using the $ sign, and the $ sign must be entered at the end of a word only. $5 is assumed if n is not specified.

* (asterisk)

telecom* finds items with words of any length containing the root "telecom" (e.g. “telecom,” “telecommunications,” “telecommute,” “telecommuting”). 
Note: At least 3 characters must be typed before using the * sign, and the * sign must be entered at the end of a word only. No number is allowed following the truncation.

?

globali?ation finds items containing the words "globalization" or "globalisation."
Note: At least 3 characters must be typed before using the ? sign.