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