Using Lookup Lists

You can define lookup lists for individual fields. When Stylus Studio converts the input file, it replaces the string in the input file (the lookup) with the value you have defined for it in the Lookup List dialog box. Figure 191 shows an example of a lookup list that has been defined for a Status field:

Figure 191. Sample Lookup List

For any Status fields in the input document with a value of, say, 100, Stylus Studio would convert that value to Continue in the XML document it outputs; values of 202 would be converted to Accepted; and so on.

Input file values that do not match a lookup are emitted in the XML document as-is, allowing exceptional values to be decoded. For example, you might have a temperature lookup list with these values for a <Temperature> field:

32 | Freeze

212 | Boil

All other temperatures would be emitted as-is.

Defining Lookup Lists

Lookups are case-sensitive, so, for example, a lookup of bmw would not match any of the Make fields in the following sample file:

Moto Guzzi,LeMans,2001,12393  


You can define lookup lists only for fields in rows for which a match pattern (even a blank match pattern, as is the default) exists. Finally, you can paste comma- and tab-delimited text directly into the lookup list. This allows you to easily reuse existing lookup tables without having to re-enter text.

To define a lookup list:
1. Select a row for which a match pattern exists.
2. Click the Lookup List entry field in the Properties window.

The Lookup List dialog box appears.

Figure 192. Lookup List Dialog Box

3. Enter lookup/value pairs in the corresponding entry fields.
4. When you are done, click OK.

Working with Lookup Lists

The following table summarizes the functions of the Lookup List dialog box, which allow you to work with new and existing lookup lists.

Commits the lookup list to the adapter.
Closes the Lookup List dialog box without committing any changes.
Copies the lookup list.
Pastes comma- and tab-separated text into the lookup list. Replaces existing content, regardless of which row you have selected
Adds comma- and tab-separated text to the end of the lookup list. Existing lookup list content is preserved.
Adds a new row to the lookup list.
Removes the selected row from the lookup list.
Table 21. Lookup List Dialog Box Buttons



Copy, Paste, and Append use the system clipboard and insert at the current cursor location. Any blank rows are discarded when you save the lookup list.

Free Stylus Studio XML Training:
W3C Member