Hi Dan,
I'm in a similar situation (not zip code specific but leading zeros specific) but using external data. I have the current code, which is pulling the rec field instead of the "DITKT#" or "DDTKT#" fields. Any help is appreciated.
Thanks,
Ryan
//Calling data from an external data file
var ex = new ExternalDataFileEx('ppfinalfltb.csv', ',');
var cursor = ex.SortBy('KEY1');
var rec = cursor.FindRecords(Field('KEY1'));
if (((ex.GetFieldValue(rec, 'RDAT01') !='') && ex.GetFieldValue(rec,'DITKT#') != '') && (ex.GetFieldValue(rec,'DDTKT#') != ''))
{
return ex.GetFieldValue (rec, FormatNumber('0000000000000', Trim('DDTKT#'))) + ', ' + ex.GetFieldValue (rec, FormatNumber('0000000000000', Trim('DITKT#')));
}
if ((ex.GetFieldValue(rec,'RDAT01') !='') && (ex.GetFieldValue(rec,'DITKT#') != ''))
{
return ex.GetFieldValue (rec, FormatNumber('0000000000000', Trim('DDTKT#')));
}
if (ex.GetFieldValue(rec,'GROUND') !='')
{
return RawText('Our records indicate that have elected to make your own flight arrangements. Therefore, we do not have your ticket number(s) on file.');
}
return '';