From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Michael Nolan <htfoot(at)gmail(dot)com> |
Cc: | Christopher Molnar <cmolnar65(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Regex help again (sorry, I am bad at these) |
Date: | 2015-12-29 22:16:48 |
Message-ID: | CAKFQuwZ=ySKFyL6DX1Z9o1-PRZ5YQEzZAbHXikoYPgyQuLaJvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 29, 2015 at 2:26 PM, Michael Nolan <htfoot(at)gmail(dot)com> wrote:
> On Mon, Dec 28, 2015 at 2:08 PM, Christopher Molnar <cmolnar65(at)gmail(dot)com>
> wrote:
>
>> Hello all!
>>
>> Sorry to have to ask the experts here for some regex assistance again. I
>> am admittadly awful with these and could use some help.
>>
>> Any suggestions?
>>
>
> I have found over the years that it is far easier to write a short PHP or
> PERL program to do tasks like this. Much easier to debug and the speed
> improvement by using SQL is not important for 200,000 records.
>
>
If all you end up doing is using regular expressions in Perl then I'm not
sure how that solves the "inexperienced at regular expressions"
problem...so what kind (if any) of non-regex based solution would
you implement to accomplish this goal. I'll admit that, being familiar
with regular expressions, I probably tend to resort to them by default now
when other solutions - if I stopped to think of them - would be less
matrix-y.
Obviously a simple find-replace is unlike to work well though some form of
"split-and-rearrange" could work - but URLs seem to want the flexibility
since defining split points in one seems challenging.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Colson | 2015-12-29 22:52:21 | cannot get stable function to use index |
Previous Message | Michael Nolan | 2015-12-29 21:26:54 | Re: Regex help again (sorry, I am bad at these) |