In an earlier example, we looked at the use of the DataManager VBScript node to reformat the record date field of our data. Another example where data may be valid yet still in constant include scenarios such as the value of the sex field.

The Male, M, Female, F, 1, or 2 values are all perhaps valid values yet these inconstant responses make visualization of data challenging. Using the VBScript node can easily address this example. Again, using the power and flexibility of VBScript, you might use the code shown in the following screenshot:

As we mentioned earlier in this chapter, it is common to have to cross-reference or translate information across data sources and the VBScript mode can be used in some cases; however, if the number of possible values are numerous (as we saw when we...