Let's cut to the chase here. Let us know what you actually want to do and
we'll help you sort it out.
we'll help you sort it out.
On Thu, Jun 23, 2011 at 10:06 AM, Steven Gotschall <sgotschall@...>wrote:
> **
>
>
> Try
>
> If Left(Customer.CustID,3) = "NOV" Then "NOV Mission US" Else ""
>
> From: "michael.hutcheson@..." <michael.hutcheson@...
> >
> To: vantage@yahoogroups.com
> Sent: Thursday, June 23, 2011 9:09 AM
>
> Subject: [Vantage] Re: Wildcard in BAQ
>
>
> I tried the following but I get an error when I click on analysis:
>
> IF Customer.CustID BEGINS "NOV" then "NOV Mission US"
>
> Thanks for your help.
>
> --- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
> >
> > Good Day:
> >
> > OR: use Begins, but no need for an *. Just Begins "N"
> >
> >
> > len.hartka@...
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Blake Clemens
> > Sent: Thursday, June 23, 2011 8:37 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: Wildcard in BAQ
> >
> >
> >
> >
> > Just to be clear... you are trying to get a "*" in your BAQ formula?
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of michael.hutcheson@...
> > <mailto:michael.hutcheson%40rocketmail.com>
> > Sent: Thursday, June 23, 2011 8:29 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Wildcard in BAQ
> >
> > I don't follow.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > Try to copy and paste it from a Word document.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of michael.hutcheson@
> > > Sent: Thursday, June 23, 2011 6:41 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Wildcard in BAQ
> > >
> > >
> > >
> > >
> > >
> > > Hey folks,
> > >
> > > How do I create a wildcard in a BAQ? I need to create field for all
> > > customer
> > > ID's starting with the letter N
> > >
> > > For example, I have created a calculated field with the below:
> > >
> > > IF Customer.CustID = "N*" then "something interesting"
> > >
> > > I have also tried:
> > >
> > > IF Customer.CustID BEGINS "N*" then "something interesting"
> > >
> > > And
> > >
> > > IF Customer.CustID BEGINS 'N*' then "something interesting"
> > >
> > > All to no avail.
> > >
> > > Can anyone help?
> > >
> > > Regards,
> > >
> > > Michael
> > >
> > > Vantage 8.03.406
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and then
> delete the message without using, disseminating, or copying this message or
> any portion thereof. With e-mail communications you are urged to protect
> against viruses.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
>
>
--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*
*
*
[Non-text portions of this message have been removed]