Problem with filter and regex

Peter Haworth pete at lcsql.com
Thu Jul 10 13:10:07 EDT 2014


I think adding the tab at the end of the pattern will ensure this works, so:

^[a-z]\d+\t

Somewhat depends on exactly what he's looking for  with the regex but the
important part is the ^ and the \t with the rest being dependent on the
format of what he's looking for.


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 8:21 AM, Charles E Buchwald <charles at buchwald.ca>
wrote:

> OK, then how about this:
> ^[a-z]\d+
> That translates as... start of line, plus 1 alphabetic character, plus one
> or more digits.
> - Charles
>
> On 10 Jul 2014, at 10:06 AM, Magicgate Software - Skip Kimpel <
> skip at magicgate.com> wrote:
>
> > I additionally noticed that if my search term is b108 it also pulls over
> > b108-option1, b108-option2, etc.
> >
> > I need it to only filter b108 and not those other items.
> >
> >
> > On Thu, Jul 10, 2014 at 10: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
>



More information about the use-livecode mailing list