Description
Searches the left column of a cross-reference file for a value and returns the corresponding value from the right column.
Syntax
FILELOOKUP ( TextSourceField, "filename", "section" )
Parameter | Description |
---|---|
TextSourceField | The value for which to search in the left column. The search is case sensitive. |
filename | The name of the cross-reference file. This file is a text
file, structured like a Windows *.INI file. If the file is not located in the same directory as the DTS file, you must enter the full path (using the UNC) to the file. |
section | The section name within the file that stores the cross-reference values. The section name is enclosed in square brackets in the *.INI file. |
Remarks
Useful for substituting full values for codes or vice versa.
Examples
The following example uses this cross-reference file named XREF.INI.
[Title_Code]
1=Owner
2=President
3=Manager
4=Executive Director
5=Principal
This function returns Manager:
FILELOOKUP("3", "XREF.INI", "Title_Code")
See also