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

24342RE: [Clip] Advice to add 'Tabs' to data.

Expand Messages
  • Robin Chapple
    Feb 13, 2014
    • 0 Attachment

      Thanks John,

      I will keep the clip and compare next time.

      Cheers,

      Robin

      At 14/02/2014 09:30 AM, you wrote:
       

      Slightly smaller and fasterÂ…

      ^!Replace "^\d+-\d+\K\x20+" >> "\t" ARWS

       

      Regards,
      John
      RecipeTools Web Site: http://recipetools.gotdns.com/
      John's Mags Yahoo Group:  http://groups.yahoo.com/group/johnsmags/

       

      From: ntb-clips@yahoogroups.com [ mailto:ntb-clips@yahoogroups.com] On Behalf Of Don
      Sent: Thursday, February 13, 2014 14:26
      To: ntb-clips@yahoogroups.com
      Subject: Re: [Clip] Advice to add 'Tabs' to data.

       

       

      Give this a whirl:

      ^!Replace "^(\d+-\d+) +" >> "$1\t" WRASTI

      I assume that the part between name and club is already as you want it
      to be. Otherwise try the following:

      ^!Replace "^(\d+-\d+) +(.*?) +" >> "$1\t$2\t" WRASTI

      On 2/13/2014 5:14 PM, Robin Chapple wrote:
      >
      > Thanks Axel and my apology for scant information.
      >
      > The existing is:
      >
      > 1996-97 Graeme Beck Rotary Club of Benalla
      > 1997-98 Geoff McIlvenna Rotary Club of Preston
      > 1998-99 Neville Miles Rotary Club of Kyabram
      > 1999-2000 Terry Grant Rotary Club of Sunbury
      >
      > I need it to be
      >
      > 1996-97 Graeme Beck Rotary Club of Benalla
      > 1997-98 Geoff McIlvenna Rotary Club of Preston
      > 1998-99 Neville Miles Rotary Club of Kyabram
      > 1999-2000 Terry Grant Rotary Club of Sunbury
      >
      >

    • Show all 18 messages in this topic