@Paul, to defend you, it's not always so obvious to know what we can or cannot do with regex.
@Mike yes, Perl is great and that's certainly why I have embeded Perl in LiveCode, Mmm, more than 10 years ago. I've also helped some well known LiveCoders to do some complex transformation with Perl where they were lost in pure LiveCode script; but this is another story. By the way, there is a not free LiveCode library called sunnYrex which accepts LiveCode script inside the replacement text.. pretty cool too but not useful in Paul use case. Kind regards, Thierry 2017-06-05 15:23 GMT+02:00 Paul Dupuis via use-livecode < use-livecode@lists.runrev.com>: > 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. > >> > -- ------------------------------------------------ Thierry Douez - sunny-tdz.com sunnYrex - sunnYtext2speech - sunnYperl - sunnYmidi - sunnYmage _______________________________________________ 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