Problem with filter and regex

Thu Jul 10 14:47:33 EDT 2014

Hi Skip,
I just tried your code in a test stack using LC 6.6.2

The data I used was:

AP6003<tab>xyz
AP6003BF<tab>Replacement for AP6003
AP6003XY<tab>def

Only line 1 was selected.

It's possible I'm misinterpreting the way your data is laid out.

Are you sure that tRegExp has "AP6003" in it?  And that your data is using
tabs between items?  Obvious stuff I know but sometimes the obvious is hard
to spot!

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Thu, Jul 10, 2014 at 10:50 AM, Magicgate Software - Skip Kimpel <
skip at magicgate.com> wrote:

> And once gain, it appears to be because AP600BF includes in it's line
> description "AP6003 is a replacement part for...."  So it is still getting
> confused.
>
>
> On Thu, Jul 10, 2014 at 1:45 PM, Magicgate Software - Skip Kimpel <
> skip at magicgate.com> wrote:
>
> > It is still thinking that AP6003 and AP60003BF are the same... I am
> using:
> > filter lines of tdg2Text with regex pattern "^"&tRegexp&"\t" into tTemp
> > (where tRegexp=AP6003)
> >
> > Hmmmmm...
> >
> >
> > On Thu, Jul 10, 2014 at 1:30 PM, Magicgate Software - Skip Kimpel <
> > skip at magicgate.com> wrote:
> >
> >> The problem is that the item does not always start with either a number
> >> or a letter... it can be different every time.  So I am thinking the
> >> ^yourregexpattern\t method is the way to go... I will try it out and let
> >> you know!
> >>
> >> SKIP
> >>
> >>
> >> On Thu, Jul 10, 2014 at 11:10 AM, Charles E Buchwald <
> charles at buchwald.ca
> >> > wrote:
> >>
> >>> So... ^yourregexpattern\t
> >>> ^ is the start of line marker
> >>> \t is the (usual) regex for a tab character
> >>> - Charles
> >>>
> >>> On 10 Jul 2014, at 9:05 AM, Magicgate Software - Skip Kimpel <
> >>> skip at magicgate.com> wrote:
> >>>
> >>> > I am reading the data from a datagrid into a variable before applying
> >>> the
> >>> > filter so it would be a TAB delimiter.
> >>> >
> >>> >
> >>> > On Thu, Jul 10, 2014 at 9:52 AM, John Craig <john at splash21.com>
> wrote:
> >>> >
> >>> >> Which item delimiter are you using?  For example, if it's a TAB,
> >>> maybe you
> >>> >> can specify a pattern ending with a tab, but disallowing any further
> >>> tabs..
> >>> >>
> >>> >>
> >>> >>
> >>> >> On 10/07/2014 14:42, Magicgate Software - Skip Kimpel wrote:
> >>> >>
> >>> >>> I think I have found the cause of the issue, now I need to figure
> >>> out how
> >>> >>> to solve it.
> >>> >>>
> >>> >>> The regex pattern I am looking for appears in other lines because
> >>> there is
> >>> >>> a description field that lists "related parts."  The one
> consistency
> >>> I
> >>> >>> have
> >>> >>> is that the pattern I am comparing to should be looking only at
> >>> column 1
> >>> >>> of
> >>> >>> tdg2Text
> >>> >>>
> >>> >>> I know this is not accurate but is there a way to say something
> like
> >>> this:
> >>> >>> filter lines of ITEM1 of tdg2Text with regex pattern tRegexp into
> >>> tTemp
> >>> >>>
> >>> >>> Trying to limit the filter based on the first item in that line VS
> >>> the
> >>> >>> entire line.
> >>> >>>
> >>> >>> Ideas?
> >>> >>>
> >>> >>> Thank you,
> >>> >>> SKIP
> >>> >>>
> >>> >>>
> >>> >>>
> >>> >>> On Wed, Jul 9, 2014 at 2:02 PM, Bernard Devlin <bdrunrev at gmail.com
> >
> >>> >>> wrote:
> >>> >>>
> >>> >>> I haven't use the filter by regex pattern, but perhaps try putting
> >>> the
> >>> >>>> "End
> >>> >>>> of Line" marker ($) at the end of your regex.  You may need the
> >>> "Start of
> >>> >>>> Line" marker too.
> >>> >>>>
> >>> >>>> ^.*cat.*mat$
> >>> >>>>
> >>> >>>> ^ is the Start of Line marker.
> >>> >>>>
> >>> >>>> Bernard
> >>> >>>>
> >>> >>>>
> >>> >>>> On Wed, Jul 9, 2014 at 4:28 PM, Magicgate Software - Skip Kimpel <
> >>> >>>> skip at magicgate.com> wrote:
> >>> >>>>
> >>> >>>> Hello LC'ers
> >>> >>>>>
> >>> >>>>> I am comparing two lists using the following:
> >>> >>>>>        filter lines of tdg2Text with regex pattern tRegexp into
> >>> tTemp
> >>> >>>>>
> >>> >>>>> The problem I have is that this is pulling up multiple lines in
> >>> tdg2Text
> >>> >>>>> when if fact I need to filter out a specific line.  tRegExp
> should
> >>> MATCH
> >>> >>>>> (exactly) item 1 of tdg2Text.
> >>> >>>>>
> >>> >>>>> Make sense?
> >>> >>>>>
> >>> >>>>> SKIP
> >>> >>>>> _______________________________________________
> >>> >>>>> use-livecode mailing list
> >>> >>>>> use-livecode at lists.runrev.com
> >>> >>>>> Please visit this url to subscribe, unsubscribe and manage your
> >>> >>>>> subscription preferences:
> >>> >>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>> >>>>>
> >>> >>>>> _______________________________________________
> >>> >>>> use-livecode mailing list
> >>> >>>> use-livecode at lists.runrev.com
> >>> >>>> Please visit this url to subscribe, unsubscribe and manage your
> >>> >>>> subscription preferences:
> >>> >>>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>> >>>>
> >>> >>>> _______________________________________________
> >>> >>> use-livecode mailing list
> >>> >>> use-livecode at lists.runrev.com
> >>> >>> Please visit this url to subscribe, unsubscribe and manage your
> >>> >>> subscription preferences:
> >>> >>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>> >>>
> >>> >>>
> >>> >>
> >>> >> _______________________________________________
> >>> >> use-livecode mailing list
> >>> >> use-livecode at lists.runrev.com
> >>> >> Please visit this url to subscribe, unsubscribe and manage your
> >>> >> subscription preferences:
> >>> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>> >>
> >>> > _______________________________________________
> >>> > use-livecode mailing list
> >>> > use-livecode at lists.runrev.com
> >>> > Please visit this url to subscribe, unsubscribe and manage your
> >>> subscription preferences:
> >>> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >>>
> >>> --
> >>> Charles E. Buchwald
> >>> CEO/Director General
> >>> Museografica Digital
> >>> http://digital.museografica.com
> >>>
> >>> LC Developer Tools: http://buchwald.ca/developer-tools/
> >>>
> >>> Email Notice: http://wp.me/P3aT4d-33
> >>>
> >>>
> >>> _______________________________________________
> >>> use-livecode mailing list
> >>> use-livecode at lists.runrev.com
> >>> Please visit this url to subscribe, unsubscribe and manage your
> >>> subscription preferences:
> >>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>>
> >>
> >>
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>