topic Re: Filtering with respect to specified position in the value of a field in App Development

Filtering with respect to specified position in the value of a field

ajit_aarya — Thu, 23 Jun 2022 16:53:25 GMT

I want to select only specified values in my field

As example

Code

USFYKAU8I

USIKSAU9U

USKJ1SHSW

I want only codes which start with US and sixth letter should be A.

I tried this =If(WildMatch(Code,'US***A***'), Code)

but its giving all fields which has U,S,A in the code and i need only sixth letter A

#expressions #logi

rwunderlich — Thu, 23 Jun 2022 18:53:57 GMT

Use the ? wildcard which indicates a single character.

=If(WildMatch(Code,'US???A???'), Code)

ajit_aarya — Thu, 23 Jun 2022 19:37:42 GMT

That works, Thanks

ajit_aarya — Fri, 01 Jul 2022 19:25:14 GMT

I want only codes which start with US and sixth letter should be A.

Exclude

I also want to eliminate letter U on ninth position

If(WildMatch(Code,'US??????U'),'Unspecified') --- condition to exclude code ends with U i guess

=If(WildMatch(Code,'US???A???',If(WildMatch(Code,'US???A???','Unspecified'), Code)

Is it works

rwunderlich — Tue, 05 Jul 2022 13:12:37 GMT

I might write it as:

=If(WildMatch(Code,'US???A???') and not Mid(Code,9,1) = 'U', Code, 'Unspecified')