Look Up / Look Up Replace

Syntax

Look Up             database_name
Look Up Replace

In entries.ini (optional companions):

Look Up             database_name
Auto Add
Search Entire Field
Look Up Replace

Parameters

Parameter	Description
database_name	The name of the lookup database file without extension (e.g., ZIP for ZIP.DTA)
Look Up Replace	Overwrites existing field values with looked-up data instead of preserving them
Auto Add	(entries.ini) Automatically adds new entries to the lookup database when an unmatched key is encountered
Search Entire Field	(entries.ini) Forces matching against the full field length instead of a prefix match

Description

Look Up retrieves information from another database and fills in fields based on a key match. For example, looking up a ZIP code to auto-fill city and state. Look Up Replace overwrites existing data with the looked-up values.

The lookup source is a separate RunScore .DTA file in the race folder (historically called a "look up database" in the old manual — not a distinct command).

Remarks

• Works in both .lst listing files and entries.ini.
• Without Replace, existing non-empty field values are preserved.
• With Look Up Replace, existing data is overwritten by the looked-up values.
• The key field (e.g., ZIP) must exist in both the main database and the lookup database; matched fields fill by name.
• The lookup database file (e.g., ZIP.DTA) must be in the race folder.

Examples

Look up city and state from a ZIP code database:

Look Up             ZIP

Overwrite existing values with looked-up data:

Look Up Replace
Look Up             ZIP

In entries.ini:

LOOK UP             ZIP