APRIL 2020 PCWorld 133engines. The Boolean operators AND
and OR must be in all-caps to function
as an operator. In Google, the Boolean
NOT operator is the minus sign; for
example, to list all alternative energy
sources EXCEPT nuclear, type this in the
search field box: list all
alternative energy sources
–nuclear.
- RIGHT & TEXT-TO-
COLUMNS
Imagine that your boss just sent you a file
with 100,000 names and addresses
compiled from several data dumps off
multiple different database systems, such as
Oracle RDBMS, SAP Sybase ASE, Informix,
MongoDB, Redis, and Couchbase. The file is
in a CSV (comma separated values) delimited
format, so you can open it in Excel, but the
delimiters are all over the place—some are
commas, some are spaces, some are tabs,
and so on. Your job is to reformat the run-on
data into five fields: Name, Address1,
Address2, City, and State.
A. First, separate the city, state, and ZIP
codes into different columns. Select column
C (City, State, ZIP), then choose Data > Text
To Columns. Ensure the Delimited button is
checked, then click Next. On the next
screen, ensure that the Comma box is
checked, then click Next. Browse through
the list to ensure the separation is correct,
then click Finish. Excel divides the one
column into two.
B. Now we need to separate the ZIP
codes from the state names. For this task,
the Text To Columns option would not be
accurate, because the only delimiter
available is a space. Because some of the
states have multiple names such as Prince
Edward Island, the Text To Columns function
would spread the data across too many
columns.
C. The solution is to use the =RIGHT
function. Because some of the ZIP codesUsing the NOT Boolean operator.