Hi,
I am developing a XMLPORT to read Credit Card information from .csv file.
For some credit cards only last four digits are available. So I want to filter my TABLE.FIELD based on these last 4 numbers.
I am trying like
TABLE.SETFILTER(FIELD, '*4[1..10]');
But its not working?
*This post is locked for comments
Thanks!
this line worked for me
TABLE.SETFILTER(FIELD_that_needed_filter , STRSUBSTNO('*%1', COPYSTR(textVariable, STRLEN(textVariable)-3, 4)))
textvariable has values
1. **** **** **** **** 1234
2. **** **** **** **** 5678
3. **** **** **** **** 2345
4. **** **** **** **** 3466
You can do a COPYSTR for last 4 digits and then do a filter om this.
What you want to filter for, do you want search a specific four digit number from the list if so then you can use the SETFILTER
record.SETFILTER("Credit Card No.",'*%1', yourfourdigitvalue)
Thanks Suresh!
Let me explain a bit, the field has data like this
**** **** **** 3456
**** **** **** 1234
**** **** **** 9087
**** **** **** 6754
These preceding stars can be numbers or stars.
I have to filter last four places and last four places in the string can be any number.
I am working in NAV 2017.
Thanks Suresh!
Let me explain a bit, the field has data like this
**** **** **** 3456
**** **** **** 1234
**** **** **** 9087
**** **** **** 6754
These preceding stars can be numbers or stars.
I have to filter last four places and last four places in the string can be any number.
I am working in NAV 2017.
I hope you are trying to find the records where the last four digit starts with 4, in that case you could try like this *4???
Share
Report
All responses (
Answers (
6,755
