Parser support a few functions for data processing:
Substitute allows to change the parsed value from list.
function Substitute(CodeValue, CodeList, ValueList: string): string;
For example, to post the 1 instead Male and 2 instead Female:
SEX=SUBSTITUTE('Male', 'Male;Female', '1;2')
Lookup allows to locate the parsed value in another dataset and post in
target dataset the value of another field value if required record
found.
function Lookup(DatasetName, CodeFieldName, CodeValue, NameFieldName:
string): string;
For example:
STATE=LOOKUP(qryStates, 'CODE', 'IL', 'NAME') {will return the
"Illinois"}