Lookup Tables
Problems with Lookups
Lookup tables may cause difficulty by not working, the reasons are always simple but can be hard to find.
No Trim
This is the top cause of lookup issues where a data field is appended or otherwise used in the lookup string and does not match. Check the data field has option Trim at the Search and replace: prompt.
Failure to trim spaces from a data field means the lookup includes spaces, where the lookup table does not, and no match is possible.
Manual Edits NOT using UTF-8 or inclusion of data copied from other files (PDF for example)
The other main cause of not finding lookups occurs when table entries are added that are not UFT-8 files or copied from files with different values - normally punctuation and the "no-break space" (0x0A), indistinguishable when viewed. These are hard to find and require delete and re-keying of characters to match what comes from FormTrap.
As an example, a user had a lookup Name copied from a PDF
file as "soft hyphen" (0xDC) while the FormTrap "hyphen-minus"
(0x2D) is indistinguishable when viewed, no match possible.
You can key another lookup entry where Name appears to
identical to the entry that is not working, if that is allowed then
look at the two entries using a hex editor (then delete the
incorrect entry). Test the lookup now works.
Inter-Line Spacing Does Not Work
Line spacing is impacted by what is in the original source of
lookup Value where the characters that cause the line break
vary between sources.
If this issue occurs, delete
from the last character in the preceding line to the first character
in the next line, inclusive.
Now key in last-character, ENTER(s) and first character of the next line
to replace what was there.