[RndTbl] Wrong time of night for doing regex?
Hartmut W Sager
hwsager at marityme.net
Sat Jan 4 12:52:49 CST 2020
> 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>
More information about the Roundtable
mailing list