You’re offline. This is a read only version of the page.
422
Hi,
I have invoice number given in 'Remarks' along with few other values in it.
I want to filter this 'Remarks' column with invoice numbers as @*invoiceNumber* in coding !.
Any way for this?
Regards,
Abdul Rahman
*This post is locked for comments
Thanks Mohana, Rafael & Robertas,
STRPOS may not help as the same string repeats for other than invoice number, let me try Robertas's suggestion.
Thanks again to all !.
Abdul !.
Hi
is it that you need all records where field Remark holds the invoice number?
If so, you can use Record.SETFILTER(Remarks, '%1', '@*InvoiceNo*');
the 'Record' is the record variable of the table in question.
Robertas
Did you try STRPOS function?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (