*WILDCARD in Dream Writer data selection

[chemker]

Hello -

Has anyone used the *WILDCARD in dream writer data selection. We cannot find any good documentation on exactl how this works and wonder if anyone has any.

Thank you.

Christy

 

[Jim_rubino]

Christy,

It is a bit tricky to use. Here is what you have to do:
If you are wanting to select records where the field starts with a
certain value, then on your data selection line enter EQ in Rel and in
the Value field enter *WILDCARD and press enter. On the Wildcard screen
enter double quote your test value and an asterisk then double quote,
like this: "WIRE*" then press enter. So for the field item description
it would find all item master records with the description starting with
WIRE.
If you want all Item Master records with the word WIRE anywhere in the
description, then place an asterisk before the W like this: "*WIRE*".

I hope this helps. If not then contact me for more help.

Jim Rubino
Fike Corporation

 

[dpfmoore]

Re: RE: *WILDCARD in Dream Writer data selection

Jim, do you know how we would use *wildcard to omit a record when a period(.) is found in a field? Something like "*.*" is how we would code it but how do we omit?
Thanks!
Dan Moore

 

[Jim_rubino]

RE: RE: *WILDCARD in Dream Writer data selection

Dan, you would use the "*.*" and NE *WILDCARD in your data selection.

Jim