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

17404Re: Need to reorder some fields

Expand Messages
  • dracorat
    Feb 5 10:57 AM
    • 0 Attachment
      Here is the proper command:
      ^!Replace "^([^;]*);([^;]*);([^;]*);([^;\r]*)(.*)?$" >>
      "$1;$2;$4;$3$5" AWRS

      --Keith

      --- In ntb-clips@yahoogroups.com, "B.P. de Vries" <bauke@...> wrote:
      >
      > Axel (and the others), thanks
      >
      > But when I use this : ^!Replace "^(.*?);(.*?);(.*?);(.*?)$" >>
      > "$1;$2;$4;$3" ATIWRS
      > in a clip I get the fourth field as the third, but I'm missing the new
      > fourth field (the old third field).
      >
      > Something is missing but what?
      >
      > Met vriendelijke groet,
      >
      > *Bauke P. de Vries
      > *
      >
      >
      >
      > Axel Berger schreef:
      > > "B.P. de Vries" wrote:
      > >
      > >> So I have to have the contents of field 4 in field 3 and
      > >> the contents of field 3 in field 4.
      > >> Is there a quick way to do this?
      > >>
      > >
      > > Do you need a generic way to this often or do you only want it done
      > > once?
      > >
      > > If the latter the easiest way is use any program that can read and
      write
      > > .CSV and do it there. The one you have probably got is M$-Excel.
      > >
      > > A bit more effort is a Regex replace (done here for 2 and 3):
      > > ^(.*?);(.*?);(.*?);(.*?)$
      > > $1;$3;$2;$4
      > >
      > > Axel
      > >
      > >
      > > Fookes Software: http://www.fookes.com/
      > > Fookes Software Discussion Lists: http://www.fookes.com/groups.php
      > > Yahoo! Groups Links
      > >
      > >
      > >
      > >
      > >
      >
      >
      > [Non-text portions of this message have been removed]
      >
    • Show all 14 messages in this topic