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