Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

Search the value located at particular position

In "Jus Ask Innovator", we could find below search tips: ● Use * or % as wildcards. ● Use * on its own to select non-blank values. But if it's possible to search the value located at particular position? For example, I want to find part numbers which contain "2" at 4th position and "G" at 6th, below results will match: ● AA12DG127 ● AB12DG965 ● XGE2FG457 ● Z912FG451 And below numbers shall not match: ● A2DG127ED ● FGD27EGD

3 Replies

  • Hi, I have tried multiple Regex and I don't think we support everything but at least you could do : [0-Z][0-Z][0-Z]2[0-Z]G*
  • Hi YOANN, Your suggestion is very useful! Thanks a lots. But in other cases, if it's possible to contain symbols such as "-", "/"?