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

clip for inserting dots into number string

Expand Messages
  • Mike Breiding - Morgantown WV
    Greetings, I have about 300 phone numbers like this: xxxxxxxxxx I want to change them to this: xxx.xxx.xxxx Anyone have a ready made clip to do this? Thanks.
    Message 1 of 11 , Aug 13, 2010
    • 0 Attachment
      Greetings,
      I have about 300 phone numbers like this:
      xxxxxxxxxx

      I want to change them to this:
      xxx.xxx.xxxx

      Anyone have a ready made clip to do this?
      Thanks.
      -Mike


      --


      Morgantown WV

      www.EpicRoadTrips.us
    • diodeom
      ... ^!Replace b d{3} K d{3}(?= d{4} b) .$0 . WARS
      Message 2 of 11 , Aug 13, 2010
      • 0 Attachment
        Mike Breiding - Morgantown WV <mike@...> wrote:
        >
        >
        > Greetings,
        > I have about 300 phone numbers like this:
        > xxxxxxxxxx
        >
        > I want to change them to this:
        > xxx.xxx.xxxx
        >
        > Anyone have a ready made clip to do this?
        > Thanks.
        > -Mike
        >

        ^!Replace "\b\d{3}\K\d{3}(?=\d{4}\b)" >> "\.$0\." WARS
      • Mike Breiding - Morgantown WV
        ... I cannot get this to work. Clip as made: ============ phonenumber dots ^!Replace b d{3} K d{3}(?= d{4} b) .$0 . WARS ============ Thanks, -Mike
        Message 3 of 11 , Aug 13, 2010
        • 0 Attachment
          diodeom wrote:
          > Mike Breiding - Morgantown WV <mike@...> wrote:
          > >
          > >
          > > Greetings,
          > > I have about 300 phone numbers like this:
          > > xxxxxxxxxx
          > >
          > > I want to change them to this:
          > > xxx.xxx.xxxx
          > >
          > > Anyone have a ready made clip to do this?
          > > Thanks.
          > > -Mike
          > >
          >
          > ^!Replace "\b\d{3}\K\d{3}(?=\d{4}\b)" >> "\.$0\." WARS

          I cannot get this to work.

          Clip as made:
          ============
          phonenumber dots

          ^!Replace "\b\d{3}\K\d{3}(?=\d{4}\b)" >> "\.$0\." WARS
          ============

          Thanks,
          -Mike
        • diodeom
          ... Are your phone numbers strings of continuous ten digits?
          Message 4 of 11 , Aug 13, 2010
          • 0 Attachment
            Mike Breiding - Morgantown WV <mike@...> wrote:
            >
            > diodeom wrote:
            > > Mike Breiding - Morgantown WV <mike@> wrote:
            > > >
            > > >
            > > > Greetings,
            > > > I have about 300 phone numbers like this:
            > > > xxxxxxxxxx
            > > >
            > > > I want to change them to this:
            > > > xxx.xxx.xxxx
            > > >
            > > > Anyone have a ready made clip to do this?
            > > > Thanks.
            > > > -Mike
            > > >
            > >
            > > ^!Replace "\b\d{3}\K\d{3}(?=\d{4}\b)" >> "\.$0\." WARS
            >
            > I cannot get this to work.
            >
            > Clip as made:
            > ============
            > phonenumber dots
            >
            > ^!Replace "\b\d{3}\K\d{3}(?=\d{4}\b)" >> "\.$0\." WARS
            > ============
            >
            > Thanks,
            > -Mike
            >

            Are your phone numbers strings of continuous ten digits?
          • John Shotsky
            One simple way to do it is this: ^!Replace b( d d d) K( d d d)( d d d d) b .$2 .$3 ARSTW I assume there is no prefix, such as 1 on any of these
            Message 5 of 11 , Aug 13, 2010
            • 0 Attachment
              One simple way to do it is this:
              ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
              I assume there is no prefix, such as '1' on any of these phone numbers. If there are, you could
              rewrite it as this:
              ^!Replace "\b(\d)?(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$3\.$4" ARSTW
              If you would need a period after that hypothetical '1' the clip would have to be rewritten so the
              period would only be there if the 1 was there.
              Regards,
              John

              From: ntb-clips@yahoogroups.com [mailto:ntb-clips@yahoogroups.com] On Behalf Of Mike Breiding -
              Morgantown WV
              Sent: Friday, August 13, 2010 03:19
              To: ntb-clips@yahoogroups.com
              Subject: [Clip] clip for inserting dots into number string



              Greetings,
              I have about 300 phone numbers like this:
              xxxxxxxxxx

              I want to change them to this:
              xxx.xxx.xxxx

              Anyone have a ready made clip to do this?
              Thanks.
              -Mike

              --

              Morgantown WV

              www.EpicRoadTrips.us



              [Non-text portions of this message have been removed]
            • Mike Breiding - Morgantown WV
              ... Yes, in a column such as: 3042910020 3042910020 3042910020 Thanks, -Mike
              Message 6 of 11 , Aug 13, 2010
              • 0 Attachment
                diodeom wrote:

                > Are your phone numbers strings of continuous ten digits?

                Yes, in a column such as:
                3042910020
                3042910020
                3042910020


                Thanks,
                -Mike
              • Mike Breiding - Morgantown WV
                ... Greetings, They are all in this format 3042910020 (hoped for result:304.291.0020)and in a column. When I open the file which contains the column of numbers
                Message 7 of 11 , Aug 13, 2010
                • 0 Attachment
                  John Shotsky wrote:
                  > One simple way to do it is this:
                  > ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
                  > I assume there is no prefix, such as '1' on any of these phone numbers.
                  > If there are, you could
                  > rewrite it as this:
                  > ^!Replace "\b(\d)?(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$3\.$4" ARSTW
                  > If you would need a period after that hypothetical '1' the clip would
                  > have to be rewritten so the
                  > period would only be there if the 1 was there.
                  > Regards, John

                  Greetings,
                  They are all in this format 3042910020 (hoped for
                  result:304.291.0020)and in a column.
                  When I open the file which contains the column of numbers and I launch
                  the clip and nothing happens.


                  >
                  > From: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                  > [mailto:ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>]
                  > On Behalf Of Mike Breiding -
                  > Morgantown WV
                  > Sent: Friday, August 13, 2010 03:19
                  > To: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                  > Subject: [Clip] clip for inserting dots into number string
                  >
                  >
                  >
                  > Greetings,
                  > I have about 300 phone numbers like this:
                  > xxxxxxxxxx
                  >
                  > I want to change them to this:
                  > xxx.xxx.xxxx
                  >
                  > Anyone have a ready made clip to do this?
                  > Thanks.
                  > -Mike
                  >
                  > --
                  >
                  > Morgantown WV
                  >
                  > www.EpicRoadTrips.us
                • John Shotsky
                  Not sure why. It works for me: ^!Replace b( d d d) K( d d d)( d d d d) b .$2 .$3 ARSTW 304.291.0020 304.291.0020 304.291.0020 304.291.0020
                  Message 8 of 11 , Aug 13, 2010
                  • 0 Attachment
                    Not sure why. It works for me:
                    ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020
                    304.291.0020

                    Regards,
                    John


                    -----Original Message-----
                    From: ntb-clips@yahoogroups.com [mailto:ntb-clips@yahoogroups.com] On Behalf Of Mike Breiding -
                    Morgantown WV
                    Sent: Friday, August 13, 2010 06:09
                    To: ntb-clips@yahoogroups.com
                    Subject: Re: [Clip] clip for inserting dots into number string

                    John Shotsky wrote:
                    > One simple way to do it is this:
                    > ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
                    > I assume there is no prefix, such as '1' on any of these phone numbers.
                    > If there are, you could
                    > rewrite it as this:
                    > ^!Replace "\b(\d)?(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$3\.$4" ARSTW
                    > If you would need a period after that hypothetical '1' the clip would
                    > have to be rewritten so the
                    > period would only be there if the 1 was there.
                    > Regards, John

                    Greetings,
                    They are all in this format 3042910020 (hoped for
                    result:304.291.0020)and in a column.
                    When I open the file which contains the column of numbers and I launch
                    the clip and nothing happens.


                    >
                    > From: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                    > [mailto:ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>]
                    > On Behalf Of Mike Breiding -
                    > Morgantown WV
                    > Sent: Friday, August 13, 2010 03:19
                    > To: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                    > Subject: [Clip] clip for inserting dots into number string
                    >
                    >
                    >
                    > Greetings,
                    > I have about 300 phone numbers like this:
                    > xxxxxxxxxx
                    >
                    > I want to change them to this:
                    > xxx.xxx.xxxx
                    >
                    > Anyone have a ready made clip to do this?
                    > Thanks.
                    > -Mike
                    >
                    > --
                    >
                    > Morgantown WV
                    >
                    > www.EpicRoadTrips.us


                    ------------------------------------

                    Fookes Software: http://www.fookes.com/
                    NoteTab website: http://www.notetab.com/
                    NoteTab Discussion Lists: http://www.notetab.com/groups.php

                    ***
                    Yahoo! Groups Links
                  • Mike Breiding - Morgantown WV
                    ... I know why - I am a big dummy! I was running the clip in 4.95 Works fine in 5.7 Sorry about that... -Mike ... -- Morgantown WV www.EpicRoadTrips.us
                    Message 9 of 11 , Aug 13, 2010
                    • 0 Attachment
                      John Shotsky wrote:
                      >
                      >
                      > Not sure why. It works for me:

                      I know why - I am a big dummy!
                      I was running the clip in 4.95
                      Works fine in 5.7

                      Sorry about that...
                      -Mike

                      > ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      > 304.291.0020
                      >
                      > Regards,
                      > John
                      >
                      > -----Original Message-----
                      > From: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                      > [mailto:ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>]
                      > On Behalf Of Mike Breiding -
                      > Morgantown WV
                      > Sent: Friday, August 13, 2010 06:09
                      > To: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                      > Subject: Re: [Clip] clip for inserting dots into number string
                      >
                      > John Shotsky wrote:
                      > > One simple way to do it is this:
                      > > ^!Replace "\b(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$2\.$3" ARSTW
                      > > I assume there is no prefix, such as '1' on any of these phone numbers.
                      > > If there are, you could
                      > > rewrite it as this:
                      > > ^!Replace "\b(\d)?(\d\d\d)\K(\d\d\d)(\d\d\d\d)\b" >> "\.$3\.$4" ARSTW
                      > > If you would need a period after that hypothetical '1' the clip would
                      > > have to be rewritten so the
                      > > period would only be there if the 1 was there.
                      > > Regards, John
                      >
                      > Greetings,
                      > They are all in this format 3042910020 (hoped for
                      > result:304.291.0020)and in a column.
                      > When I open the file which contains the column of numbers and I launch
                      > the clip and nothing happens.
                      >
                      > >
                      > > From: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                      > <mailto:ntb-clips%40yahoogroups.com>
                      > > [mailto:ntb-clips@yahoogroups.com
                      > <mailto:ntb-clips%40yahoogroups.com> <mailto:ntb-clips%40yahoogroups.com>]
                      > > On Behalf Of Mike Breiding -
                      > > Morgantown WV
                      > > Sent: Friday, August 13, 2010 03:19
                      > > To: ntb-clips@yahoogroups.com <mailto:ntb-clips%40yahoogroups.com>
                      > <mailto:ntb-clips%40yahoogroups.com>
                      > > Subject: [Clip] clip for inserting dots into number string
                      > >
                      > >
                      > >
                      > > Greetings,
                      > > I have about 300 phone numbers like this:
                      > > xxxxxxxxxx
                      > >
                      > > I want to change them to this:
                      > > xxx.xxx.xxxx
                      > >
                      > > Anyone have a ready made clip to do this?
                      > > Thanks.
                      > > -Mike
                      > >
                      > > --
                      > >
                      > > Morgantown WV
                      > >
                      > > www.EpicRoadTrips.us
                      >
                      > ------------------------------------
                      >
                      > Fookes Software: http://www.fookes.com/
                      > NoteTab website: http://www.notetab.com/
                      > NoteTab Discussion Lists: http://www.notetab.com/groups.php
                      >
                      > ***
                      > Yahoo! Groups Links
                      >
                      >

                      --


                      Morgantown WV

                      www.EpicRoadTrips.us
                    • diodeom
                      ... In this case the notation could be even further stripped of redundancy: ^!Replace ^ d{3} K d{3} .$0 . WARS Perhaps test first how it works via the
                      Message 10 of 11 , Aug 13, 2010
                      • 0 Attachment
                        Mike Breiding - Morgantown WV <mike@...> wrote:
                        >
                        > diodeom wrote:
                        >
                        > > Are your phone numbers strings of continuous ten digits?
                        >
                        > Yes, in a column such as:
                        > 3042910020
                        > 3042910020
                        > 3042910020
                        >
                        >
                        > Thanks,
                        > -Mike
                        >

                        In this case the notation could be even further stripped of redundancy:

                        ^!Replace "^\d{3}\K\d{3}" >> "\.$0\." WARS

                        Perhaps test first how it works via the "manual" replace dialog (Ctrl+R) with Regular Exp. checked. The search pattern ^\d{3}\K\d{3} should highlight fourth, fifth and sixth digits. The replacement \.$0\. should place dots around that selection.
                      • flo.gehrke
                        ... Hi Dio, I love those RegEx which do not capture anything. So if we ve got a pure one-column list like that we could also write just... ^!Replace
                        Message 11 of 11 , Aug 14, 2010
                        • 0 Attachment
                          --- In ntb-clips@yahoogroups.com, "diodeom" <diomir@...> wrote:
                          >
                          > > 3042910020
                          > > 3042910020
                          > > 3042910020
                          >
                          > In this case the notation could be even further stripped of
                          > redundancy:
                          >
                          > ^!Replace "^\d{3}\K\d{3}" >> "\.$0\." WARS

                          Hi Dio,

                          I love those RegEx which do not capture anything. So if we've got a pure one-column list like that we could also write just...

                          ^!Replace "\d{3}\K(?=\d{3})" >> "." AWRS

                          BTW, you could strip even more: There's no need to escape the dot in the replacement string here ;-)

                          Regards,
                          Flo
                        Your message has been successfully submitted and would be delivered to recipients shortly.