Problem with filter and regex

[Peter Haworth]

You could also do this without using a regexp:

filter tdg2Text with (tRegExp & tab & "*") into field "Field2"

Just in case there's something weird happening with the regexp....

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
>