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 < s...@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 < > s...@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 < > > s...@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 < > char...@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 < > >>> s...@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 <j...@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 <bdrun...@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 < > >>> >>>> s...@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@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@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@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
