How to SETFILTER for last 4 digits?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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???

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

You can do a COPYSTR for last 4 digits and then do a filter om this.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No