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 <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 -- 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
