Listbox by charactor

[everest226]

I have this value in  AP Booking field

5464364ad

3655fcvgh453ddf

5465434TP

45fgfg4TP

I only want to display Value which has  TP at the end

[bharathadde · Accepted solution]

Here you go, try this

=if(wildmatch([AP Booking field],'*TP'),[AP Booking field])

[everest226]

Thanks