Retrieve list of codes by value pattern from XX/1 lookup tables.

var strCode = Encode(strTable, strMatch); 

Parameters

• strTable : [in] String, name of XX/1 lookup table.
• strMatch : [in] String, text or partial text that is used to match the <desc> text value of the table

 

Return Values

String containing an XML with list of <ce> code entries of the table where match is found.

Example:

<cl>
    <ce>
        <code>JFK</code>
        <desc>New York-JFK, NY, US</desc>
    </ce>
    <ce>
        <code>LGA</code>
        <desc>New York-La Guardia, NY, US</desc>
    </ce>
    <ce>
        <code>NYC</code>
        <desc>New York City Regional Airports, NY, US</desc>
    </ce>
</cl> 

Remarks

This function performs well also on large size tables.

 

Example

var strCode = Encode(Airports, "New York");