130
Hi all,
I am able to filter a field on a specific page to only include relevant results.
However, I would like to implement a RegEx (or some method) so that I filter results once, and then filter again for results that start with 3 letters (E.g. ABC , DEF, CAT)
Any thoughts?
Hi, In that case, you can try to extract the first three characters, and then use a loop to determine whether they are all alphabetical letters.
The following is an example of judging whether it is a number, I think it can be used as a reference.
http://adnavtech.blogspot.com/2017/06/how-to-check-string-is-number-or-letter.html
Hope this helps.
Thanks.
ZHU
Hi Zhu,
I feel privileged to get an answer from you! I read your posts all the time!
Unfortunately the letters are not fixed, what I'd like is to filter out anything that begins with 3 alphabetical letters ([a-z])
Hi, are these three letters fixed?
If so it's relatively simple.
For example, you can use following ABC* to represent data beginning with ABC.
Item.SETFILTER("No.",'ABC*');
Hope this can give you some hints.
Thanks.
ZHU
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
