Databases Reference
In-Depth Information
2.
Click on the
Delete Marked
button to remove these rows. They should
instantly disappear.
3.
Now, click on the
Conditional Delete…
button to continue removing the
weekly totals. A new window will appear, shown below, in which we will
specify the condition on which the remaining rows should be removed.
4.
Make sure, as in the preceding screenshot, to set the following parameters:
° The
Compare with value
radio button should be selected
° The comparison operator will be set to
contains
° The comparison value will be the word
Total
° The
Case Sensitive
and
Not
options should be disabled
5.
Click on the
Add
button to finish setting the condition and then click on
OK
to return to the previous window.
The preceding procedure will remove the garbage from our file, but that is not all we
need to do.
