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

20622Re: regex help ....

Expand Messages
  • flo.gehrke
    May 3, 2010
      --- In ntb-clips@yahoogroups.com, Don <don@...> wrote:
      >
      > ReynoldsburgGause, Destinee1 12.35q
      >
      > to become
      >
      > Reynoldsburg[tab]Gause[tab]Destinee[tab]1[tab]12.35
      >
      > There may or may note be a q at the end.
      >
      > Another example:
      > Oak RidgeDelong, Christina22 13.86
      >
      > to
      >
      > Oak Ridge[tab]Delong[tab]Christina[tab]22[tab]13.86
      >
      > Look back from the comma for a capital letter or something?
      >

      Just another idea (one long line)...

      ^!Replace "((?<=[[:lower:]])(?=[[:upper:]])|\x20|(?<=[[:lower:]])(?=\d))" >> "\t" AWRS

      Flo
    • Show all 6 messages in this topic