Thank you Thierry and everyone else.
I should have realized that I couldn't do this entirely with regex due
to the need to compare the number values. It was a long day yesterday
and my brain just wasn't in full gear.
-- Paul
On 6/5/2017 4:06 AM, Thierry Douez via use-livecode wrote:
> Hi Paul,
>
>
> AFAIK you need to deal with an hybrid approach (regex + livecode)
>
> So, here is one way to do it:
>
>
> put 3 into pPage
>
> repeat for each line T in tCiCData
>
> if matchText( T, "(?x) \t (\d+) , \d+ , (\d+) , \d+ \z", n1, n2)
> then
>
> if (n1 <= pPage) and (n2 >= pPage) then
>
> put T & cr after tCiCfilteredData
>
> end if
>
> end if
>
> end repeat
>
> put tCiCfilteredData
>
>
> But for the curious with an open-mind here is another solution:
>
>
> get "perl -ne 'print if /\t(\d+),\d+,(\d+),\d+$(?(?{$1>PP ||
> $2<PP})(*FAIL))/'"
>
> get replaceText( IT, "PP", pPage)
>
> put shell( IT && "/your/path/CiCData.txt")
>
>
> What? the regex do the comparison!
> Well yes and no; in Perl we can embed Perl code *inside* the regex,
> like: (?{$1>PP || $2<PP})
>
> $1>PP || $2<PP is a Perl expression.
>
> As we have a mixture of a regex pattern and some perl code;
> that is in fact another hybrid solution.
>
>
> And of course, you can do it using only chunks , item and so on...
>
>
> Have fun,
>
> Thierry
>
>
>
>
> 2017-06-04 17:35 GMT+02:00 Paul Dupuis via use-livecode <
> use-livecode@lists.runrev.com>:
>
>> I have a tab and cr delimited table of data, a sample line of which is
>> below:
>>
>> 1<tab>Test<tab>4052,12594<tab>1,4052,3,2388<cr>
>>
>> Can someone help me revise this regex to match what I need?
>>
>> Thank you kindly, in advance.
>>
_______________________________________________
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
