Problem with filter and regex

Thu Jul 10 15:39:39 EDT 2014

MYSTERY SOLVED.... The previous code DID IN FACT WORK:
filter lines of tdg2Text with regex pattern "^"&tRegexp&"\t" into tTemp

The Problem?  What was showing on screen was correct... when I went to
output the file, I was not using the same regex pattern. Whoops....

Thanks to all for helping out!

SKIP

On Thu, Jul 10, 2014 at 2:16 PM, Charles E Buchwald <charles at buchwald.ca>
wrote:

> Hi SKIP,
>
> Now I'm confused!
>
> I usually start a thorny programming problem by trying to state the logic
> in plain English. Would either of the following phrases properly filter
> your data if it could be expressed as regex?
>
> the first item of a line, which begins with a letter or number, but always
> has a series of digits, which may or may not be followed by a series of one
> or more letters, always followed by a tab
>
> or is it...
>
> the first item of a line, which begins with a letter or number, but always
> has a series of digits, which may or may not be followed by a series of one
> or more letters or other characters not included digits, always followed by
> a tab or a space
>
> Maybe posting several sample lines of your data would help us list members
> help you...
>
> - Charles
>
> On 10 Jul 2014, at 12:50 PM, 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
>
> --
> 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
>