Problem with filter and regex

Magicgate Software - Skip Kimpel skip at magicgate.com
Thu Jul 10 13:45:39 EDT 2014


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



More information about the use-livecode mailing list