Problem with filter and regex

[Magicgate Software - Skip Kimpel]

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
>>>
>>
>>
>