[RndTbl] Wrong time of night for doing regex?

[Hartmut W Sager]

> What tool are you using to run the regex?

Oops, I forgot to answer that.  Vedit (the text editor) runs regex
internally.  I don't know whether they programmed that part themselves, or
are using code from elsewhere.

> if I'm understanding what you want to do (prepend 0s to dates and remove
the comma).

In the simplified test case, yes (plus de-blanking the extra blanks), but
in the real case, it's much more than that, including a re-ordering of
"fields" to match the mbox spec.

Hartmut W Sager - Tel +1-204-339-8331


On Sat, 4 Jan 2020 at 10:58, Mark Campbell <nitrodist at gmail.com> wrote:

> I don't think you can use \s in the replacement regex as it has no special
> meaning there. In my local testing with perl, it seems to treat it as a
> literal escape for the letter s. What tool are you using to run the regex?
>
> Substitute in a space, seems to work as expected:
>
> 2020-01-04 10:45:30 ~ TOR-M001 %: ccat test | perl -pe
> 's/(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\s+([0-9])[\s\,]+/\1
> 0\2 /'
> From AncientBBS1 Thu  Jan 07 1986  20:50:00
> 2020-01-04 10:45:35 ~ TOR-M001 %: ccat test
> From AncientBBS1 Thu  Jan  7, 1986  20:50:00
>
> What might be easier (and more readable) is if each line has a fixed
> length from the beginning, you can match perhaps a little more clearly by
> doing something like s/^(.{23}) (\d),/\1 0\2/ if I'm understanding what
> you want to do (prepend 0s to dates and remove the comma).
>
>
> On Sat, Jan 4, 2020 at 10:27 AM Hartmut W Sager <hwsager at marityme.net>
> wrote:
>
>>
>> [... deleted ...]
>>
>> _______________________________________________
>> Roundtable mailing list
>> Roundtable at muug.ca
>> https://muug.ca/mailman/listinfo/roundtable
>>
> _______________________________________________
> Roundtable mailing list
> Roundtable at muug.ca
> https://muug.ca/mailman/listinfo/roundtable
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://muug.ca/pipermail/roundtable/attachments/20200104/59bfc6fa/attachment.html>