Quote:
Originally Posted by
RudiC
Do you have TABs as field separators?
Given the spacing between fields in the sample input, I was guessing that tabs could have been converted to spaces in the copy and paste process. redder will have to let us know whether the real data has spaces, tabs, or a mix.
I chose a BRE that would work either way.
To expand on what MadeInGermany said:
\digit expands to the string that was matched by the BRE between the
\( and the matching
\) where the
digit (1 through 9) refers to the 1st through the 9th
\( to indicate which matched expression is to be included in the replacement text. In the expression I gave, \1 expands to
HH:MM: from the matched timestamp. So
\100expands to the matched hours and minutes with the seconds replaced by
00.