BAQ - "Does Not Begin With" Filter

Yahoo Archive
1
That did it. Brilliantly simple.

Thanks!
Â
Keith Walter
Vantage Coordinator
Norgren Automation Solutions, Saline Division
keith.walter@...




________________________________
From: Kirstin Brandt <kirstin.brandt@...>
To: vantage@yahoogroups.com
Sent: Mon, March 22, 2010 3:19:56 PM
Subject: [Vantage] Re: BAQ - "Does Not Begin With" Filter

Â
Maybe try partnum < "96" or partnum >= "97"?

--- In vantage@yahoogroups .com, "Keith" <keithfwalter@ ...> wrote:
>
> In the phrase builder will not allow Substring(part. partnum,1, 2) in the field column in BAQ entry. Am I missing something?
>
> --- In vantage@yahoogroups .com, "Carl Peterson" <cpeterson@> wrote:
> >
> > Substring(part. partnum,1, 2) <> "96"
> >
> > If several, you could do lookup(substring( part.partnum, 1,2),"48, 76,96") = 0
> >
> > Carl Peterson
> >
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
> > Keith
> > Sent: Friday, March 19, 2010 9:04 AM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] BAQ - "Does Not Begin With" Filter
> >
> >
> > I need to filter a BAQ for parts that do not begin with a specific string.
> > Does anyone know how to do this? I have tried: <> "96*" to filter out any
> > parts that do not begin with "96" - it does not work.
> >
> > Thanks,
> >
> > Keith Walter
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>







[Non-text portions of this message have been removed]
2
I need to filter a BAQ for parts that do not begin with a specific string. Does anyone know how to do this? I have tried: <> "96*" to filter out any parts that do not begin with "96" - it does not work.

Thanks,

Keith Walter
3
Just thinking out loud here, and not really thinking about BAQ syntax,
but is there a way to use do something like:

TRIM("9630",2) <> "96"

--A
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith
Sent: Friday, March 19, 2010 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - "Does Not Begin With" Filter




I need to filter a BAQ for parts that do not begin with a specific
string. Does anyone know how to do this? I have tried: <> "96*" to
filter out any parts that do not begin with "96" - it does not work.

Thanks,

Keith Walter






[Non-text portions of this message have been removed]
4
Substring(part.partnum,1,2) <> "96"

If several, you could do lookup(substring(part.partnum,1,2),"48,76,96") = 0

Carl Peterson

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Keith
Sent: Friday, March 19, 2010 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - "Does Not Begin With" Filter


I need to filter a BAQ for parts that do not begin with a specific string.
Does anyone know how to do this? I have tried: <> "96*" to filter out any
parts that do not begin with "96" - it does not work.

Thanks,

Keith Walter



[Non-text portions of this message have been removed]
5
This would be easier to do in Crystal if this BAQ is going to a report.
Create a formula field that does this.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith
Sent: Friday, March 19, 2010 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ - "Does Not Begin With" Filter





I need to filter a BAQ for parts that do not begin with a specific
string. Does anyone know how to do this? I have tried: <> "96*" to
filter out any parts that do not begin with "96" - it does not work.

Thanks,

Keith Walter





[Non-text portions of this message have been removed]
6
In the phrase builder will not allow Substring(part.partnum,1,2) in the field column in BAQ entry. Am I missing something?

--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Substring(part.partnum,1,2) <> "96"
>
> If several, you could do lookup(substring(part.partnum,1,2),"48,76,96") = 0
>
> Carl Peterson
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Keith
> Sent: Friday, March 19, 2010 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ - "Does Not Begin With" Filter
>
>
> I need to filter a BAQ for parts that do not begin with a specific string.
> Does anyone know how to do this? I have tried: <> "96*" to filter out any
> parts that do not begin with "96" - it does not work.
>
> Thanks,
>
> Keith Walter
>
>
>
> [Non-text portions of this message have been removed]
>
7
Maybe try partnum < "96" or partnum >= "97"?

--- In vantage@yahoogroups.com, "Keith" <keithfwalter@...> wrote:
>
> In the phrase builder will not allow Substring(part.partnum,1,2) in the field column in BAQ entry. Am I missing something?
>
> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@> wrote:
> >
> > Substring(part.partnum,1,2) <> "96"
> >
> > If several, you could do lookup(substring(part.partnum,1,2),"48,76,96") = 0
> >
> > Carl Peterson
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > Keith
> > Sent: Friday, March 19, 2010 9:04 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ - "Does Not Begin With" Filter
> >
> >
> > I need to filter a BAQ for parts that do not begin with a specific string.
> > Does anyone know how to do this? I have tried: <> "96*" to filter out any
> > parts that do not begin with "96" - it does not work.
> >
> > Thanks,
> >
> > Keith Walter
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>