If Match and Not WildMatch

[Betty1]

I have the following in my load data script.  The first part works fine, but the results include line numbers beginning with 77 or 88.  Would appreciate any help on where this is incorrect.  Thanks.

If(Match([Appointment Type (Position)],'FTT', 'PTT','INT') and
(Not Wildmatch([Local Line Number], '77*','88*')), 1, Null()) AS [CIV-TEMP/TERM],

[chrismarlow · Accepted solution]

Hi,

If your Local Line Number is numeric, try wrapping in a Text function;

If(Match([Appointment Type (Position)],'FTT', 'PTT','INT') and
(Not Wildmatch(Text([Local Line Number]), '77*','88*')), 1, Null()) AS [CIV-TEMP/TERM],

Cheers,

Chris.

[Betty1]

Thanks Chris.  That seems to have worked perfectly.