Hi,

I want to create a filter that does pattern matching and I am not sure how.

Our project name should follow this format '99999-999...' Where 9 is a numeric and the '...' can be anything (I don't care about that part.)

An example would be '12345-678 Test project"

 How can I accomplish this?

 You are concatenating fields, not pattern matching correct?  Assuming these are two data items you can unlock the report and physically place the two data items together, using a text object to create spacing if needed.

Unlock:

 Drop the data item inside the other (in the body, not the header)  Here we already have Project Number and want to add Project Name right along side it.

End result:

You can apply column title formatting to change the name, insert text between the two data items (I inserted 2 spaces which is why mine are spaced apart) and such...  When you run the report it appears as:

9999999 Project X

Hi Steve,

I am trying to pattern match. In the query designer part. I create a query that returns a field - project name - that follows this format '99999-999...' Where 9 is a numeric and the '...' can be anything (I don't care about that part.) (Your solution concatinates 2 fields, the field in the db is already concatenated.)

An example would be '12345-678 Test project"

 I want to filter that query to show records that do follow that pattern - five numerics a hyphen and 3 numerics. (I really want the ones that do NOT follow this pattern but I think I can figure out the "Not" part to reverse it.)

Note: that is a cool tip that you passed along that I will use in the future.