The criteria wizard only seems to have numeric comparators (=, <, >, <>, etc.,) and not the MATCHES I would expect would absolutely work with *your-phrase* if all progress language was suported in the wizard.
I think you might have to construct a calculated field with an If statement (True if your table.field MATCHES *your-phrase*, else FALSE) and then use sorting to effectively get the result you want.
Perhaps someone knows a better way???
Rob
I think you might have to construct a calculated field with an If statement (True if your table.field MATCHES *your-phrase*, else FALSE) and then use sorting to effectively get the result you want.
Perhaps someone knows a better way???
Rob
--- On Thu, 12/11/08, brucewbrannan <bruce.brannan@...> wrote:
From: brucewbrannan <bruce.brannan@...>
Subject: [Vantage] Re: Walmart
To: vantage@yahoogroups.com
Date: Thursday, December 11, 2008, 4:34 PM
Is it possible to create a BAQ that will search for text like
*sometext*, like with wildcard characters?
For example, I want to see all LaborDtl.LaborNote records with the
text TM-74 in them. In MS Access I would search for:
"*" & [Enter the text: ] & "*" (and I would enter TM-74)
Thanks!
--- In vantage@yahoogroups .com, "Chris Robisch" <bluewine@.. .> wrote:
>
> To retain leading zeroes for a .csv file which normally is opened
by Excel, you must turn it into a formula. For example if your value
is 0123, you would store it as ="0123". This would make it a left-
justified text field as well.
>
> ----- Original Message -----
> From: "brucewbrannan" <bruce.brannan@ ...>
> To: <vantage@yahoogroups .com>
> Sent: Thursday, December 11, 2008 6:37 AM
> Subject: [Vantage] Re: Walmart
>
>
> If the csv field formats require special formatting (like preceding
> zeros) then good luck with a BAQ. But if you figure out how to do
it
> I'd love to know.
>
> If you can provide a sample of what the upload should look like
then
> I'd take a look at it. We run weekly and monthly exports to upload
> into other financial systems but not through BAQs.
>
> --- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ >
> wrote:
> >
> > No ties to Walmart, but you should be able to create a BAQ
> containing the data they are interested in (and in the layout
> desired) and then just export it to csv (just as you can export BAQ
> returned datasets to xml).
> >
> > Rob
> >
> >
> >
> > --- On Wed, 12/10/08, RICH WAGNER <rwagner@> wrote:
> > From: RICH WAGNER <rwagner@>
> > Subject: [Vantage] Walmart
> > To: "vantage@yahoogroups .com" <vantage@yahoogroups .com>
> > Date: Wednesday, December 10, 2008, 4:58 PM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Does anyone else out there deal with Walmart? Are
you
> required to upload csv files to their PO Tracking system?
> >
> >
> >
> > I would like to know how you are creating your csv.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Rich Wagner
> >
> >
> >
> > [cid:image002. jpg@ 01C95AE8. ]
> >
> >
> >
> >
> >
> >
> >
> > rwagner@bawplastics .com<mailto: rwagner@bawplast ics .com>
> >
> >
> >
> > www.bawplastics. com<http://www.bawplast ics.com/>
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>