Searching Excel and CSV Files for Dates of Birth

The Match Every Date as a Date of Birth in CSV and Excel Files, If the File Contains a DOB keyword setting allows you to specify when Spirion finds numeric dates of birth with AnyFind. When searching for dates of birth with AnyFind, a date is only considered a date of birth if there are relevant keywords near that date to indicate that it is a date of birth. The Match Every Date as a Date of Birth in CSV and Excel Files, if the file contains a DoB keyword setting changes that behavior for Excel and CSV files to allow all dates to be considered dates of birth if there are relevant keywords anywhere in the location. This is useful for lists of dates as you might see in an Excel file, where you might want every single occurrence of a date found.  Select this checkbox to match every date in the file if a keyword exists anywhere in the location.

To view or change these settings, click the Preferences button on the toolbar then select AnyFind and select Dates of Birth from the dropdown. Alternatively, you can click the Data Types button on the toolbar, then select Manage AnyFind... and select Dates of Birth from the dropdown or select Preferences in the Spirion menu and select AnyFind and then select Dates of Birth from the dropdown.