Question Variations
Can I add a wildcard to the primary key field in the lookup table
Applies To
Lookup table
Answer
A wildcard (*, asterisk) is a symbol used to replace or represent zero or more characters. This can be used in the primary key in a lookup table to replace some characters of the data.
Please note that it requires a prefix and cannot be placed at the beginning. For example, using "user*" would match entries like "user1", "username", or "user123", but "*user" or "*user*" would not be valid.
For a lookup table usage example, consider the caller ID field and associate it with a destination phone number. The lookup table file might look like this:
caller_id, destination
805*, 123-456-7890
Additionally, utilizing a wildcard is supported in the primary key but not in the secondary key.
