Problem with filter and regex

[Charles E Buchwald]

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 <skip at 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 <
> skip at 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 <
>> skip at 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 <charles at 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 <
>>>> 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