Filter/Select on part of Variable

Jet Reports Historic Posts

August 14, 2008 16:13

None

Jet 7.06 Excel 2007 SQL ( Not Navision Database)

I need to be able to filter based on a portion of the field

Example Field is xxxx-xx-xxx-kk-kkk

I need to select only on the k portion

Is there a way to do a filter that is Mid(field,13,5) to match kk-kkk

Where this is headed is a sheet per kk-kkk ( Happens to be Division and Branch) but those specific fields are nto in the database and cannot be added

overtime by gl branch.xlsx

Date Votes

2 comments

0

Jet Reports Historic Posts August 14, 2008 18:45

In NAV I would create a filter like this: "????????????kk-kkk". The ? wildcard refers to a single character that could have any value.

I wonder if it works for the Universal connector too. Please let us know the result.

Comment actions Permalink
0

Jet Reports Historic Posts August 25, 2009 16:43

OOps took me long enough but yes that worked in universal

Comment actions Permalink

Please sign in to leave a comment.