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

[ajit_aarya]

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 · Accepted solution]

Use the ? wildcard which indicates a single character.

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

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[ajit_aarya]

That works, Thanks

[ajit_aarya]

@rwunderlich 

 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]

I might write it as:

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

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com