Loading ...
Sorry, an error occurred while loading the content.
 

Re: [Clip] Modify block column

Expand Messages
  • Sandy Rozhon
    Thanks Alec. One of these days I m going to have learn these regular expressions! I didn t even notice that they could be used in the replace box. How s
    Message 1 of 2 , Feb 26, 2006
      Thanks Alec. One of these days I'm going to have learn these regular
      expressions! I didn't even notice that they could be used in the
      replace box. How's that for being observant? :)

      Sandy

      On 25 Feb 2006 at 18:13, Alec Burgess(g) wrote:

      > Hi Sandy:
      > This must be my day to get on the regexp soapbox :-)
      > As I said to littlegoblin, with some study, you'd probably find that
      > it can be done fairly easily.
      >
      > For the specific example you gave this would change all dates of the
      > form yyyy-mm-dd to the form yyyy|mm/dd wherever they occur in
      > whichever column
      >
      > In replace box, tick regexp and:
      > FIND={\d\d\d\d}-{\d\d}-{\d\d}
      > REPLACE=\1|\2/\3
      >
      > Depending on exactly what you need to accomplish you might find it
      > easier to create a simple clip to "test" and "record" what you are
      > doing so that it can be redone at a later time.
      >
      > eg. this simple clip would do the job of the above Replace dialog:
      > H="change date format in columns" ^!replace "{\d\d\d\d}-{\d\d}-{\d\d}"
      > >> "\1|\2/\3" rwais
      >
      > Regards ... Alec
      > --
      > ----- Original Message -----
      > From: "Sandy Rozhon" <srozhon@...>
      > To: <ntb-clips@yahoogroups.com>
      > Sent: Saturday, February 25, 2006 3:40 PM
      > Subject: [Clip] Modify block column
      >
      >
      > > I have a file that contains columnar data that I wish to alter
      > > slightly. Instead of:
      > >
      > > L|2000-01-21|04:41|
      > >
      > > I'd like the data to look like this:
      > >
      > > L|2000|01/21|04:41|
      > >
      > > I thought I could just use the MODIFY/BLOCK command to replace
      > > column 7 with the bar "|" and similarly for the dash to slash
      > > conversion. The full line contains a lot more data than shown here,
      > > so simple search and replace isn't the answer. The ability to
      > > modify a specific column, is. Can this be done from the menu or do
      > > I need a clip? There are roughly 500 rows.
      >
      >
      >
      > Fookes Software: http://www.fookes.us, http://www.fookes.com
      > Fookes Software Mailing Lists: http://www.fookes.us/maillist.htm
      >
      > Yahoo! Groups Links
      >
      >
      >
      >
      >
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.