Groups > comp.os.linux.advocacy > #349538 > unrolled thread

Fabian: 10,000 addresses processed in 0.53 seconds with VBScript

Started by	DFS <nospam@dfs.com>
First post	2016-04-12 13:22 -0400
Last post	2016-04-17 18:21 -0400
Articles	20 on this page of 200 — 20 participants

Back to article view | Back to comp.os.linux.advocacy

  Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-12 13:22 -0400
    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Fabian Russell <fb@zen.info> - 2016-04-13 10:07 +0000
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 12:53 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Omar <omarsayeed@linuxmail.org> - 2016-04-13 13:13 -0400
    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript John Gohde <john.h.gohde@gmail.com> - 2016-04-13 11:18 -0700
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 17:13 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript John Gohde <john.h.gohde@gmail.com> - 2016-04-13 14:35 -0700
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 18:44 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript John Gohde <john.h.gohde@gmail.com> - 2016-04-15 05:39 -0700
    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-13 20:49 +0000
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 17:41 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-13 23:00 +0000
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 19:44 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-14 02:10 +0000
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 22:29 -0400
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-14 02:36 +0000
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 22:42 -0400
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-14 03:07 +0000
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-13 23:56 -0400
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-14 03:32 +0000
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-14 00:04 -0400
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-14 04:38 +0000
    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-15 19:25 +0000
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-15 19:37 +0000
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-15 16:17 -0400
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-15 13:33 -0700
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-15 16:59 -0400
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 08:11 -0700
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 11:54 -0400
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-20 00:19 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-15 21:02 +0000
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-16 08:05 -0700
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 08:56 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-16 11:28 +0000
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 19:13 +0000
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-16 21:12 +0000
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 08:51 +0000
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 14:43 +0000
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 15:16 +0000
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 16:10 +0000
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 21:38 +0000
                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 22:04 +0000
                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 07:38 +0000
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 13:08 -0400
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 21:57 +0000
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 18:15 -0400
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 07:43 +0000
                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 10:49 -0400
                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 15:08 +0000
                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 08:18 -0700
                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 11:46 -0400
                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 09:16 -0700
                                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 12:39 -0400
                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 17:43 +0000
                                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-18 14:27 -0400
                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Silver Slimer <peter@klown.is> - 2016-04-18 17:50 -0400
                                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 12:18 -0700
                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 12:27 -0700
                                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 13:13 -0700
                                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 13:46 -0700
                                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 13:51 -0700
                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:09 -0700
                                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzen@gmail.com> - 2016-04-18 14:13 -0700
                                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 14:19 -0700
                                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:23 -0700
                                                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 14:26 -0700
                                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzen@gmail.com> - 2016-04-18 14:35 -0700
                                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 21:36 +0000
                                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:38 -0700
                                                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 14:48 -0700
                                                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:56 -0700
                                                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 15:00 -0700
                                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 15:05 -0700
                                                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzen@gmail.com> - 2016-04-18 14:34 -0700
                                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzen@gmail.com> - 2016-04-18 14:34 -0700
                                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript William Poaster <wp@dev.null> - 2016-04-18 22:34 +0100
                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzen@gmail.com> - 2016-04-18 14:11 -0700
                                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:13 -0700
                                                Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-18 21:38 +0000
                                                  Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-18 14:42 -0700
                                                    Re: Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-19 05:51 +0000
                                                      Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-19 08:24 -0700
                                                        Re: Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-19 16:37 +0000
                                                          Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-19 09:49 -0700
                                                            Re: Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-19 16:53 +0000
                                                          Re: Snit digest 206 / 2016-04-18 chrisv <chrisv@nospam.invalid> - 2016-04-19 12:04 -0500
                                                            Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-19 10:15 -0700
                                                          Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 13:08 -0700
                                                            Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-19 21:14 +0000
                                                              Re: Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-19 21:39 +0000
                                                                Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-19 22:03 +0000
                                                                  Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 16:21 -0700
                                                                    Re: Snit digest 206 / 2016-04-18 Marek Novotny <marek.novotny@marspolar.com> - 2016-04-19 17:07 -0700
                                                                      Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 20:36 -0700
                                                                      Re: Snit digest 206 / 2016-04-18 DFS <nospam@dfs.com> - 2016-04-20 10:19 -0400
                                                                      Re: Snit digest 206 / 2016-04-18 DFS <nospam@dfs.com> - 2016-04-20 12:44 -0400
                                                                Re: Snit digest 206 / 2016-04-18 Richard King <kingsley651@webby.org> - 2016-04-19 18:27 -0400
                                                                  Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 16:15 -0700
                                                                    Re: Snit digest 206 / 2016-04-18 Richard King <kingsley651@webby.org> - 2016-04-19 19:32 -0400
                                                                  Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 03:39 +0000
                                                                    Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 04:01 +0000
                                                                  Snit digest 211 / 2016-04-20 Sandman <mr@sandman.net> - 2016-04-20 05:24 +0000
                                                              Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 15:01 -0700
                                                                Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-19 22:11 +0000
                                                                  Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 16:20 -0700
                                                                    Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-19 23:36 +0000
                                                                      Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 20:30 -0700
                                                                        Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 03:58 +0000
                                                                          Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 21:19 -0700
                                                                            Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 05:01 +0000
                                                                              Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 22:14 -0700
                                                                                Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 05:29 +0000
                                                                                  Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-19 22:33 -0700
                                                                                    Re: Snit digest 206 / 2016-04-18 owl <owl@rooftop.invalid> - 2016-04-20 05:52 +0000
                                                                                      Re: Snit digest 206 / 2016-04-18 vallor <vallor@cultnix.org> - 2016-04-20 16:02 +0000
                                                                                        Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-20 09:11 -0700
                                                                                        Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-20 10:40 -0700
                                                                                      Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-20 10:43 -0700
                                                                                        Re: Snit digest 206 / 2016-04-18 Steve Carroll <fretwizzer@gmail.com> - 2016-04-20 11:36 -0700
                                                                  Re: Snit digest 206 / 2016-04-18 Sandman <mr@sandman.net> - 2016-04-20 06:01 +0000
                                                  Re: Snit digest 206 / 2016-04-18 Snit <usenet@gallopinginsanity.com> - 2016-04-18 16:30 -0700
                                                    Snit digest 207 / 2016-04-19 Sandman <mr@sandman.net> - 2016-04-19 05:52 +0000
                                                      Re: Snit digest 207 / 2016-04-19 Snit <usenet@gallopinginsanity.com> - 2016-04-18 23:25 -0700
                                                        Snit digest 208 / 2016-04-19 Sandman <mr@sandman.net> - 2016-04-19 07:49 +0000
                                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 20:49 +0000
                                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 13:52 -0700
                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 21:33 +0000
                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-19 05:48 -0400
                                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Marek Novotny <marek.novotny@marspolar.com> - 2016-04-18 13:55 -0700
                                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 21:35 +0000
                                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-19 05:41 -0400
                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-18 15:52 -0400
                                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 20:47 +0000
                                      Re: Microsoft is the standard; Apple extends it; Ubuntu falls short. Fabian Russell <fb@zen.info> - 2016-04-18 22:59 +0000
                                        Re: Microsoft is the standard; Apple extends it; Ubuntu falls short. DFS <nospam@dfs.com> - 2016-04-20 10:19 -0400
                                      Re: Microsoft is the standard; Apple extends it; Ubuntu falls short. benj <nobodyxx@gmail> - 2016-04-19 00:03 -0400
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-16 13:19 -0700
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 16:25 -0400
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-16 15:08 -0700
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 18:15 -0400
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-16 15:26 -0700
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 18:35 -0400
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-16 15:51 -0700
                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-20 10:10 -0400
                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-20 08:13 -0700
                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-20 12:10 -0400
                                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Steve Carroll <fretwizzer@gmail.com> - 2016-04-20 09:12 -0700
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 09:02 +0000
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 13:31 -0400
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 21:59 +0000
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 20:06 -0400
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-18 00:24 +0000
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 07:46 +0000
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-18 05:41 -0400
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 11:01 -0400
                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Melzzzzz <mel@zzzzz.com> - 2016-04-18 17:04 +0200
                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 11:08 -0400
                            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 15:23 +0000
                              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-20 10:16 -0400
                                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-20 18:22 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 14:03 -0400
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 08:38 +0000
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-17 07:27 -0400
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 13:03 -0400
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 21:55 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 18:26 -0400
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 08:59 +0000
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 09:40 +0000
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 14:14 +0000
                  Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 15:07 +0000
                    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 15:51 +0000
                      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 21:39 +0000
                        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-17 22:09 +0000
                          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 07:40 +0000
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Silver Slimer <linux@shit.is> - 2016-04-15 17:18 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-15 19:12 -0400
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 08:57 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-16 11:29 +0000
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 18:28 -0400
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Melzzzzz <mel@zzzzz.com> - 2016-04-15 23:03 +0200
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 08:57 +0000
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Silver Slimer <linux@shit.is> - 2016-04-15 17:17 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-15 21:39 +0000
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 08:58 +0000
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-15 18:24 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 08:59 +0000
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-04-16 06:34 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-16 11:32 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Omar <omarsayeed@linuxmail.org> - 2016-04-16 09:01 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 14:02 -0400
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript owl <owl@rooftop.invalid> - 2016-04-16 11:16 +0000
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 14:02 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-16 19:12 +0000
          Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-16 14:05 -0400
            Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-17 08:40 +0000
              Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-18 10:48 -0400
                Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Sandman <mr@sandman.net> - 2016-04-18 15:06 +0000
    Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Norman Peelman <npeelman@cfl.rr.com> - 2016-04-17 09:33 -0400
      Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript DFS <nospam@dfs.com> - 2016-04-17 14:30 -0400
        Re: Fabian: 10,000 addresses processed in 0.53 seconds with VBScript Norman Peelman <npeelman@cfl.rr.com> - 2016-04-17 18:21 -0400

Page 1 of 10 [1] 2 3 … 10 Next page →

#349538 — Fabian: 10,000 addresses processed in 0.53 seconds with VBScript

From	DFS <nospam@dfs.com>
Date	2016-04-12 13:22 -0400
Subject	Fabian: 10,000 addresses processed in 0.53 seconds with VBScript
Message-ID	<nejanb$p7n$1@dont-email.me>

http://i.imgur.com/XD1A5It.jpg

Took the base 25 addresses, and copied until I had 10,000 entries.

My superior MS Windows VBScript then transformed 10,000 addresses from 4 
lines per address to one line per address (removing extraneous lines and 
words in the process), delimited it, de-duped the 10,000 rows, then 
sorted, then saved ... all in just over half a second?  WTF!?  And the 
final result was 25 unique lines, as it should be.

10,000 addresses in 0.53 seconds?  Holy Shit that's fast!  Using an i5 
WinTel PC, I can deliver a sorted 100,000 mailing label .csv file in 
just over 5 seconds!

You - and the slow, bumbling, incomprehensible New/Linux bash and perl 
crapware - CANNOT compete.  You know it and I know it.  You're fired for 
promoting that hobbyware.

I added timers and address counters to the code.  Now, when you move to 
the big leagues (Microsoft Windows and the best software on Earth), 
you'll have a nice address processing module to keep you employed.  Keep 
it with you at all times.


usage: \process_addresses.vbs inputFile outputFile




'process_addresses.vbs

Option Explicit
Dim fso, dict, strKey, strLine
Dim fIn, addressFile, addrList
dim fOut, newAddressFile
Dim delim, business, street, citystatezip
dim startTime, endTime, addressCount

Const ForReading =  1
Const ForWriting =  2
Const AdVarChar  =  200
Const MaxCharacters =  255

startTime = Timer

'-----------------------------------------------------------
'OBJECTS
'-----------------------------------------------------------
Set fso      = CreateObject("Scripting.FileSystemObject")
Set dict     = CreateObject("Scripting.Dictionary")
Set addrList = CreateObject("ADOR.Recordset")


'-----------------------------------------------------------
'SETTINGS
'-----------------------------------------------------------
delim = ";"  'don't use comma - code leaves 'City, State Zip' format in 
place
addressFile    = WScript.Arguments.Item(0)
newAddressFile = WScript.Arguments.Item(1)


'-----------------------------------------------------------
'TRANSFORM DATA TO ONE ROW PER ADDRESS
'-----------------------------------------------------------
set fIn  = fso.OpenTextFile(addressFile , ForReading)
Set fOut = fso.CreateTextFile(newAddressFile, True)
fOut.WriteLine("#Name" & delim & "Street" & delim & "CityStateZip")
addressCount = 0

Do until fIn.AtEndOfStream

   business = fIn.ReadLine
   fIn.SkipLine
   strLine = Replace(fIn.ReadLine," Call Now!","")
   street = Left(strLine, InStr(strLine,",")-1)
   citystatezip = Mid(strLine, Len(street) + 3)

   fOut.WriteLine(business & delim & street & delim & citystatezip)
   addressCount = addressCount + 1

   If Not fIn.AtEndOfStream Then fIn.SkipLine
   If Not fIn.AtEndOfStream Then fIn.SkipLine

Loop
fIn.Close
fOut.close


'-----------------------------------------------------------
'REMOVE DUPES
'-----------------------------------------------------------
set fIn = fso.OpenTextFile(newAddressFile , ForReading)
  Do until fIn.AtEndOfStream
   strLine = fIn.ReadLine
   If Not dict.Exists(strLine) Then
     dict.Add strLine, strLine
   End If
  Loop
fIn.Close
set fOut  = fso.OpenTextFile(newAddressFile , ForWriting)
  For Each strKey in dict.Keys
    fOut.WriteLine strKey
  Next
fOut.Close


'-----------------------------------------------------------
'SORT
'-----------------------------------------------------------
addrList.Fields.Append "Address", AdVarChar, MaxCharacters
addrList.Open

set fIn  = fso.OpenTextFile(newAddressFile , ForReading)
Do Until fIn.AtEndOfStream
   addrList.AddNew
   addrList("Address") = fIn.ReadLine
   addrList.Update
Loop
fIn.Close

addrList.Sort = "Address"
addrList.MoveFirst
strLine = ""
Do Until addrList.EOF
   strLine = strLine & addrList.Fields.Item ("Address") & vbCrLf
   addrList.MoveNext
Loop
addrList.Close

Set fOut = fso.OpenTextFile(newAddressFile , ForWriting)
  fOut.WriteLine strLine
fOut.Close


'-----------------------------------------------------------
'FINISHED
'-----------------------------------------------------------
endTime = Timer
WScript.Echo "Processed " & addressCount & " addresses in " & 
FormatNumber(endTime - startTime,2) & " seconds"

[toc] | [next] | [standalone]

#349642

From	Fabian Russell <fb@zen.info>
Date	2016-04-13 10:07 +0000
Message-ID	<nel5pj02bbd@news3.newsguy.com>
In reply to	#349538

> 
> My [arguably] superior MS Windows VBScript 
>

It fails miserably on the issue of PORTABILITY.

The whole point of a programming language is universality.
It should operate in any machine environment anywhere.
Languages such as Perl and C fulfill that imperative.

But Microshit VBA will operate ONLY in a Microshit environment
and ONLY within a specific VERSION of that Microshit environment
(Ha, ha, ha!  As if we can place a version number on shit.).

Any reasonable human will summarily reject that restriction.

[toc] | [prev] | [next] | [standalone]

#349689

From	DFS <nospam@dfs.com>
Date	2016-04-13 12:53 -0400
Message-ID	<neltca$cho$1@dont-email.me>
In reply to	#349642

On 4/13/2016 6:07 AM, Fabian Russell wrote:

>> My [arguably] superior MS Windows VBScript

It blows your perl junk away.

> It fails miserably on the issue of PORTABILITY.

Like Dirty Harry said: "Portability is for assholes"

And portability wasn't one of your requirements.  Your bogus claim was 
that Windows has no native tools to do that little task:

"I ain't got no tools... There's no goddamn fuckin' tools built into 
Windows that enable me to do this... we can sit back and laugh hahahaha 
at that stupid, fucked-up joke of an operating system called Microsoft 
Windows"

You still laughing thru your broken nose?

> The whole point of a programming language is universality.

Windows IS universal.  That's why you use it to make a living.

> It should operate in any machine environment anywhere.
> Languages such as Perl and C fulfill that imperative.
>
> But Microshit VBA will operate ONLY in a Microshit environment
> and ONLY within a specific VERSION of that Microshit environment
> (Ha, ha, ha!  As if we can place a version number on shit.).

Sure you can.
About LibreOffice: Version: 5.1.0.3

> Any reasonable human will summarily reject that restriction.

A reasonable human would know more about other operating systems before 
spouting "I ain't got no tools."

[toc] | [prev] | [next] | [standalone]

#349690

From	Omar <omarsayeed@linuxmail.org>
Date	2016-04-13 13:13 -0400
Message-ID	<neluhr$hei$1@dont-email.me>
In reply to	#349689

On Wed, 13 Apr 2016 12:53:37 -0400, DFS wrote:

> On 4/13/2016 6:07 AM, Fabian Russell wrote:
> 
> 
>>> My [arguably] superior MS Windows VBScript
> 
> It blows your perl junk away.
> 
> 
> 
> 
>> It fails miserably on the issue of PORTABILITY.
> 
> 
> Like Dirty Harry said: "Portability is for assholes"
> 
> And portability wasn't one of your requirements.  Your bogus claim was 
> that Windows has no native tools to do that little task:
> 
> "I ain't got no tools... There's no goddamn fuckin' tools built into 
> Windows that enable me to do this... we can sit back and laugh hahahaha 
> at that stupid, fucked-up joke of an operating system called Microsoft 
> Windows"
> 
> You still laughing thru your broken nose?
> 
> 
> 
>> The whole point of a programming language is universality.
> 
> Windows IS universal.  That's why you use it to make a living.
> 
> 
> 
>> It should operate in any machine environment anywhere.
>> Languages such as Perl and C fulfill that imperative.
>>
>> But Microshit VBA will operate ONLY in a Microshit environment
>> and ONLY within a specific VERSION of that Microshit environment
>> (Ha, ha, ha!  As if we can place a version number on shit.).
> 
> Sure you can.
> About LibreOffice: Version: 5.1.0.3
> 
> 
> 
>> Any reasonable human will summarily reject that restriction.
> 
> A reasonable human would know more about other operating systems before 
> spouting "I ain't got no tools."

If Fibian is the voice in those videos he posts it's obvious that
there is something wrong with him, mentally or otherwise.

[toc] | [prev] | [next] | [standalone]

#349696

From	John Gohde <john.h.gohde@gmail.com>
Date	2016-04-13 11:18 -0700
Message-ID	<a439f846-ac06-4f4a-b6b3-9ddcfcf91325@googlegroups.com>
In reply to	#349538

On Tuesday, April 12, 2016 at 1:23:01 PM UTC-4, DFS wrote:
> http://i.imgur.com/XD1A5It.jpg
> 
> Took the base 25 addresses, and copied until I had 10,000 entries.
> 
> My superior MS Windows VBScript then transformed 10,000 addresses from 4 
> lines per address to one line per address (removing extraneous lines and 
> words in the process), delimited it, de-duped the 10,000 rows, then 
> sorted, then saved ... all in just over half a second?  WTF!?  And the 
> final result was 25 unique lines, as it should be.


NEWSFLASH: In 2016, DooFuS has been reduced to sorting mailing labels - LOL. Yeah, that is just about his speed.

[toc] | [prev] | [next] | [standalone]

#349707

From	DFS <nospam@dfs.com>
Date	2016-04-13 17:13 -0400
Message-ID	<nemcjs$b8c$2@dont-email.me>
In reply to	#349696

On 4/13/2016 2:18 PM, John Gohde wrote:

> NEWSFLASH: In 2016, DooFuS has been reduced to sorting mailing
> labels - LOL. Yeah, that is just about his speed.


I sort them, then a brainless, toothless moron like you peels, licks and 
sticks them.

[toc] | [prev] | [next] | [standalone]

#349712

From	John Gohde <john.h.gohde@gmail.com>
Date	2016-04-13 14:35 -0700
Message-ID	<e3fae6cc-f239-4ce0-9f19-9f83f96a98bb@googlegroups.com>
In reply to	#349707

On Wednesday, April 13, 2016 at 5:13:43 PM UTC-4, DFS wrote:
> On 4/13/2016 2:18 PM, John Gohde wrote:
> 
> > NEWSFLASH: In 2016, DooFuS has been reduced to sorting mailing
> > labels - LOL. Yeah, that is just about his speed.
> 
> 
> I sort them, then a brainless, toothless moron like you peels, licks and 
> sticks them.


That wouldn't even qualify as MIS, just an old maid secretary position, Putz!

[toc] | [prev] | [next] | [standalone]

#349721

From	DFS <nospam@dfs.com>
Date	2016-04-13 18:44 -0400
Message-ID	<nemhuh$vi$2@dont-email.me>
In reply to	#349712

On 4/13/2016 5:35 PM, John Gohde wrote:
> On Wednesday, April 13, 2016 at 5:13:43 PM UTC-4, DFS wrote:
>> On 4/13/2016 2:18 PM, John Gohde wrote:
>>
>>> NEWSFLASH: In 2016, DooFuS has been reduced to sorting mailing
>>> labels - LOL. Yeah, that is just about his speed.
>>
>>
>> I sort them, then a brainless, toothless moron like you peels, licks and
>> sticks them.
>
>
> That wouldn't even qualify as MIS, just an old maid secretary position, Putz!


It's honest work.  Better than plagiarizing for a living.

[toc] | [prev] | [next] | [standalone]

#350038

From	John Gohde <john.h.gohde@gmail.com>
Date	2016-04-15 05:39 -0700
Message-ID	<ff761059-2f82-4acb-8f1f-5dcce5d5dc8a@googlegroups.com>
In reply to	#349721

On Wednesday, April 13, 2016 at 6:44:44 PM UTC-4, DFS wrote:
> On 4/13/2016 5:35 PM, John Gohde wrote:
> > On Wednesday, April 13, 2016 at 5:13:43 PM UTC-4, DFS wrote:
> >> On 4/13/2016 2:18 PM, John Gohde wrote:
> >>
> >>> NEWSFLASH: In 2016, DooFuS has been reduced to sorting mailing
> >>> labels - LOL. Yeah, that is just about his speed.
> >>
> >>
> >> I sort them, then a brainless, toothless moron like you peels, licks and
> >> sticks them.
> >
> >
> > That wouldn't even qualify as MIS, just an old maid secretary position, Putz!
> 
> 
> It's honest work.  Better than plagiarizing for a living.



You mean that DooFuS actually goes around begging for money?  I thought that the putz was making money hands over fists. The tard must have a printing press in his bathroom.

[toc] | [prev] | [next] | [standalone]

#349705

From	owl <owl@rooftop.invalid>
Date	2016-04-13 20:49 +0000
Message-ID	<hjgd03at.ay4@rooftop.invalid>
In reply to	#349538

DFS <nospam@dfs.com> wrote:
> http://i.imgur.com/XD1A5It.jpg
> 
> Took the base 25 addresses, and copied until I had 10,000 entries.
> 
> My superior MS Windows VBScript then transformed 10,000 addresses from 4 
> lines per address to one line per address (removing extraneous lines and 
> words in the process), delimited it, de-duped the 10,000 rows, then 
> sorted, then saved ... all in just over half a second?  WTF!?  And the 
> final result was 25 unique lines, as it should be.
> 
> 10,000 addresses in 0.53 seconds?  Holy Shit that's fast! 

0.24 sec is faster, though.  Linux FTW once again.

anon@lowtide:~/code/dfs$ tail -n 20 data
Walmart Supercenter
3759 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3760 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3761 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3762 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3763 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

anon@lowtide:~/code/dfs$
anon@lowtide:~/code/dfs$ grep Walmart data |wc -l
25
anon@lowtide:~/code/dfs$ cat makeem
#!/bin/bash

for i in $(seq 1 400); do cat data >> data_e;done

anon@lowtide:~/code/dfs$ ./makeem
anon@lowtide:~/code/dfs$ ls -l data_e
-rw-r--r-- 1 anon anon 609200 Apr 13 16:38 data_e
anon@lowtide:~/code/dfs$ grep Walmart data_e | wc -l
10000
anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ tail -n 20 data_e
Walmart Supercenter
3759 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3760 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3761 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3762 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

Walmart Supercenter
3763 E Andrew Johnson Hwy Ofc
Greeneville, TN 37745 

anon@lowtide:~/code/dfs$ 

anon@lowtide:~/code/dfs$ cat sortem
#!/bin/bash

sed -e 's/$/;/g' <data_e |sed -e 's/^;/WWWWW/g' |sed -z 's/\n//g' |sed -e 's/WWWWW/\n/g' |sort -u |sed -e 's/;$//g'

anon@lowtide:~/code/dfs$

anon@lowtide:~/code/dfs$ time ./sortem
Walmart;175 Ji Bell Ln;Savannah, TN 38372 
Walmart;2300 Treasury Dr SE;Cleveland, TN 37323 
Walmart;3051 Kinzel Way;Knoxville, TN 37924 
Walmart;4050 Nolensville Pike;Nashville, TN 37211 
Walmart;612 E Main St;Hohenwald, TN 38462 
Walmart;7034 Charlotte Pike;Nashville, TN 37209 
Walmart;7044 Charlotte Pike;Nashville, TN 37209 
Walmart;7046 Charlotte Pike;Nashville, TN 37209 
Walmart;7048 Charlotte Pike;Nashville, TN 37209 
Walmart;7049 Charlotte Pike;Nashville, TN 37209 
Walmart;7054 Charlotte Pike;Nashville, TN 37209 
Walmart Distribution Center;285 Frank Martin Rd;Shelbyville, TN 37160 
Walmart Supercenter;1210 Mineral Wells Ave;Paris, TN 38242 
Walmart Supercenter;3034 Rhea County Hwy;Dayton, TN 37321 
Walmart Supercenter;3755 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3756 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3757 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3758 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3759 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3760 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3761 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3762 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;3763 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745 
Walmart Supercenter;501 Signal Mountain Rd;Chattanooga, TN 37405 
Walmart Supercenter;570 Enon Springs Rd E;Smyrna, TN 37167 

real	0m0.240s
user	0m0.264s
sys	0m0.024s
anon@lowtide:~/code/dfs$

[toc] | [prev] | [next] | [standalone]

#349714

From	DFS <nospam@dfs.com>
Date	2016-04-13 17:41 -0400
Message-ID	<neme8k$h7m$1@dont-email.me>
In reply to	#349705

On 4/13/2016 4:49 PM, owl wrote:
> DFS <nospam@dfs.com> wrote:
>> http://i.imgur.com/XD1A5It.jpg
>>
>> Took the base 25 addresses, and copied until I had 10,000 entries.
>>
>> My superior MS Windows VBScript then transformed 10,000 addresses from 4
>> lines per address to one line per address (removing extraneous lines and
>> words in the process), delimited it, de-duped the 10,000 rows, then
>> sorted, then saved ... all in just over half a second?  WTF!?  And the
>> final result was 25 unique lines, as it should be.
>>
>> 10,000 addresses in 0.53 seconds?  Holy Shit that's fast!
>
> 0.24 sec is faster, though.  Linux FTW once again.
>
> anon@lowtide:~/code/dfs$ tail -n 20 data
> Walmart Supercenter
> 3759 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3760 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3761 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3762 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3763 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> anon@lowtide:~/code/dfs$
> anon@lowtide:~/code/dfs$ grep Walmart data |wc -l
> 25
> anon@lowtide:~/code/dfs$ cat makeem
> #!/bin/bash
>
> for i in $(seq 1 400); do cat data >> data_e;done
>
> anon@lowtide:~/code/dfs$ ./makeem
> anon@lowtide:~/code/dfs$ ls -l data_e
> -rw-r--r-- 1 anon anon 609200 Apr 13 16:38 data_e
> anon@lowtide:~/code/dfs$ grep Walmart data_e | wc -l
> 10000
> anon@lowtide:~/code/dfs$
> anon@lowtide:~/code/dfs$ tail -n 20 data_e
> Walmart Supercenter
> 3759 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3760 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3761 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3762 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> Walmart Supercenter
> 3763 E Andrew Johnson Hwy Ofc
> Greeneville, TN 37745
>
> anon@lowtide:~/code/dfs$
>
> anon@lowtide:~/code/dfs$ cat sortem
> #!/bin/bash
>
> sed -e 's/$/;/g' <data_e |sed -e 's/^;/WWWWW/g' |sed -z 's/\n//g' |sed -e 's/WWWWW/\n/g' |sort -u |sed -e 's/;$//g'
>
> anon@lowtide:~/code/dfs$
>
> anon@lowtide:~/code/dfs$ time ./sortem
> Walmart;175 Ji Bell Ln;Savannah, TN 38372
> Walmart;2300 Treasury Dr SE;Cleveland, TN 37323
> Walmart;3051 Kinzel Way;Knoxville, TN 37924
> Walmart;4050 Nolensville Pike;Nashville, TN 37211
> Walmart;612 E Main St;Hohenwald, TN 38462
> Walmart;7034 Charlotte Pike;Nashville, TN 37209
> Walmart;7044 Charlotte Pike;Nashville, TN 37209
> Walmart;7046 Charlotte Pike;Nashville, TN 37209
> Walmart;7048 Charlotte Pike;Nashville, TN 37209
> Walmart;7049 Charlotte Pike;Nashville, TN 37209
> Walmart;7054 Charlotte Pike;Nashville, TN 37209
> Walmart Distribution Center;285 Frank Martin Rd;Shelbyville, TN 37160
> Walmart Supercenter;1210 Mineral Wells Ave;Paris, TN 38242
> Walmart Supercenter;3034 Rhea County Hwy;Dayton, TN 37321
> Walmart Supercenter;3755 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3756 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3757 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3758 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3759 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3760 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3761 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3762 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;3763 E Andrew Johnson Hwy Ofc;Greeneville, TN 37745
> Walmart Supercenter;501 Signal Mountain Rd;Chattanooga, TN 37405
> Walmart Supercenter;570 Enon Springs Rd E;Smyrna, TN 37167
>
> real	0m0.240s
> user	0m0.264s
> sys	0m0.024s
> anon@lowtide:~/code/dfs$




Looking good to the untrained eye - and extremely impressive for a 
one-liner sed statement - but I'm all over it:

Your input data doesn't match the format of mine.  You need to:

* drop a specific phrase off the end of the 3rd line
* drop the 2nd and 4th lines
* split the street from the address line
* add a header line with a chosen delimiter
* handle a comma delimiter by removing all other commas (which slows my
   new version down from 0.33 to 0.36 seconds)


Start:
Carlitos Mexican Restaurant, Inc
RESTAURANTS MEXICAN
2445 Moon Rd, Grayson, GA 30017 Call Now!
0.3 mi


Finish (comma delimiter):
Name,Street,CityStateZip
Carlitos Mexican Restaurant Inc,2445 Moon Rd,Grayson GA 30017


Finish (semicolon delimiter):
Name;Street;CityStateZip
Carlitos Mexican Restaurant, Inc;2445 Moon Rd;Grayson, GA 30017


You can do it!

[toc] | [prev] | [next] | [standalone]

#349723

From	owl <owl@rooftop.invalid>
Date	2016-04-13 23:00 +0000
Message-ID	<hjgid9093.aef@rooftop.invalid>
In reply to	#349714

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 4:49 PM, owl wrote:
>> DFS <nospam@dfs.com> wrote:
>>> http://i.imgur.com/XD1A5It.jpg
>>>
>>> Took the base 25 addresses, and copied until I had 10,000 entries.
>>>
>>> My superior MS Windows VBScript then transformed 10,000 addresses from 4
>>> lines per address to one line per address (removing extraneous lines and
>>> words in the process), delimited it, de-duped the 10,000 rows, then
>>> sorted, then saved ... all in just over half a second?  WTF!?  And the
>>> final result was 25 unique lines, as it should be.
>>>
>>> 10,000 addresses in 0.53 seconds?  Holy Shit that's fast!
>>
>> 0.24 sec is faster, though.  Linux FTW once again.
>>
...
 
> 
> 
> Looking good to the untrained eye - and extremely impressive for a 
> one-liner sed statement - but I'm all over it:
> 
> Your input data doesn't match the format of mine.  You need to:
> 
> * drop a specific phrase off the end of the 3rd line

Trivial.

> * drop the 2nd and 4th lines

In all cases?  Might the second line be a critical part of the
address?  The "0.3 mi" thing can be regex'd out without reference
to its line number.  You sure that by-line-number is the way you
would want it handled?

> * split the street from the address line

Is that a special case for a problematic entry or would they all
be like that?

> * add a header line with a chosen delimiter
> * handle a comma delimiter by removing all other commas (which slows my
>   new version down from 0.33 to 0.36 seconds)
> 
> 
> Start:
> Carlitos Mexican Restaurant, Inc
> RESTAURANTS MEXICAN
> 2445 Moon Rd, Grayson, GA 30017 Call Now!
> 0.3 mi
> 
> 
> Finish (comma delimiter):
> Name,Street,CityStateZip
> Carlitos Mexican Restaurant Inc,2445 Moon Rd,Grayson GA 30017
> 
> 
> Finish (semicolon delimiter):
> Name;Street;CityStateZip
> Carlitos Mexican Restaurant, Inc;2445 Moon Rd;Grayson, GA 30017
> 
> 
> You can do it!
>

[toc] | [prev] | [next] | [standalone]

#349733

From	DFS <nospam@dfs.com>
Date	2016-04-13 19:44 -0400
Message-ID	<nemlee$c0v$1@dont-email.me>
In reply to	#349723

On 4/13/2016 7:00 PM, owl wrote:
> DFS <nospam@dfs.com> wrote:
>> On 4/13/2016 4:49 PM, owl wrote:
>>> DFS <nospam@dfs.com> wrote:
>>>> http://i.imgur.com/XD1A5It.jpg
>>>>
>>>> Took the base 25 addresses, and copied until I had 10,000 entries.
>>>>
>>>> My superior MS Windows VBScript then transformed 10,000 addresses from 4
>>>> lines per address to one line per address (removing extraneous lines and
>>>> words in the process), delimited it, de-duped the 10,000 rows, then
>>>> sorted, then saved ... all in just over half a second?  WTF!?  And the
>>>> final result was 25 unique lines, as it should be.
>>>>
>>>> 10,000 addresses in 0.53 seconds?  Holy Shit that's fast!
>>>
>>> 0.24 sec is faster, though.  Linux FTW once again.
>>>
> ...
>
>>
>>
>> Looking good to the untrained eye - and extremely impressive for a
>> one-liner sed statement - but I'm all over it:
>>
>> Your input data doesn't match the format of mine.  You need to:
>>
>> * drop a specific phrase off the end of the 3rd line
>
> Trivial.

You're just the man for that...


>> * drop the 2nd and 4th lines
>
> In all cases?  Might the second line be a critical part of the
> address?  The "0.3 mi" thing can be regex'd out without reference
> to its line number.  You sure that by-line-number is the way you
> would want it handled?

Yes.  Sometimes the 4th line has a website
"0.7 miwww.burgerking.com"



>> * split the street from the address line
>
> Is that a special case for a problematic entry or would they all
> be like that?


All the addresses are like that.  They were cut and pasted from a search 
I did at:

http://www.usdirectory.com

Fabian Russell used it for his mailing labels videos and perl code, so I 
used it, too.

The requirements I listed are dictated by the format of the data.  I 
added an if-then for the delimiter, just because when you say .csv file 
some people expect commas.

A gotcha to remember: using a comma delimiter means the 'City, State 
Zip' can't have a comma in it.  I like 'City, State  Zip' format, but it 
won't mess up the Post Office.

I also like # as a delimiter, or a pipe |

Another gotcha to remember: ANY character used as a delimiter can't be 
part of the address data, or the file won't parse correctly.

Your 0.24 is doubling as we speak... 0.36 is the VBS benchmark with a 
comma-delimiter, 0.33 with a semicolon or other delimiter.



>> * add a header line with a chosen delimiter
>> * handle a comma delimiter by removing all other commas (which slows my
>>    new version down from 0.33 to 0.36 seconds)
>>
>>
>> Start:
>> Carlitos Mexican Restaurant, Inc
>> RESTAURANTS MEXICAN
>> 2445 Moon Rd, Grayson, GA 30017 Call Now!
>> 0.3 mi
>>
>>
>> Finish (comma delimiter):
>> Name,Street,CityStateZip
>> Carlitos Mexican Restaurant Inc,2445 Moon Rd,Grayson GA 30017
>>
>>
>> Finish (semicolon delimiter):
>> Name;Street;CityStateZip
>> Carlitos Mexican Restaurant, Inc;2445 Moon Rd;Grayson, GA 30017
>>
>>
>> You can do it!

[toc] | [prev] | [next] | [standalone]

#349755

From	owl <owl@rooftop.invalid>
Date	2016-04-14 02:10 +0000
Message-ID	<hgjcnvod893.a83@rooftop.invalid>
In reply to	#349733

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 7:00 PM, owl wrote:
>> DFS <nospam@dfs.com> wrote:
>>> On 4/13/2016 4:49 PM, owl wrote:
>>>> DFS <nospam@dfs.com> wrote:
>>>>> http://i.imgur.com/XD1A5It.jpg
>>>>>
>>>>> Took the base 25 addresses, and copied until I had 10,000 entries.
>>>>>
>>>>> My superior MS Windows VBScript then transformed 10,000 addresses from 4
>>>>> lines per address to one line per address (removing extraneous lines and
>>>>> words in the process), delimited it, de-duped the 10,000 rows, then
>>>>> sorted, then saved ... all in just over half a second?  WTF!?  And the
>>>>> final result was 25 unique lines, as it should be.
>>>>>
>>>>> 10,000 addresses in 0.53 seconds?  Holy Shit that's fast!
>>>>
>>>> 0.24 sec is faster, though.  Linux FTW once again.
>>>>
>> ...
>>
>>>
>>>
>>> Looking good to the untrained eye - and extremely impressive for a
>>> one-liner sed statement - but I'm all over it:
>>>
>>> Your input data doesn't match the format of mine.  You need to:
>>>
>>> * drop a specific phrase off the end of the 3rd line
>>
>> Trivial.
> 
> You're just the man for that...
> 
> 
>>> * drop the 2nd and 4th lines
>>
>> In all cases?  Might the second line be a critical part of the
>> address?  The "0.3 mi" thing can be regex'd out without reference
>> to its line number.  You sure that by-line-number is the way you
>> would want it handled?
> 
> Yes.  Sometimes the 4th line has a website
> "0.7 miwww.burgerking.com"
> 
> 
> 
>>> * split the street from the address line
>>
>> Is that a special case for a problematic entry or would they all
>> be like that?
> 
> 
> All the addresses are like that.  They were cut and pasted from a search 
> I did at:
> 
> http://www.usdirectory.com
> 
> Fabian Russell used it for his mailing labels videos and perl code, so I 
> used it, too.
> 
> The requirements I listed are dictated by the format of the data.  I 
> added an if-then for the delimiter, just because when you say .csv file 
> some people expect commas.
> 
> A gotcha to remember: using a comma delimiter means the 'City, State 
> Zip' can't have a comma in it.  I like 'City, State  Zip' format, but it 
> won't mess up the Post Office.
> 
> I also like # as a delimiter, or a pipe |
> 
> Another gotcha to remember: ANY character used as a delimiter can't be 
> part of the address data, or the file won't parse correctly.
> 
> Your 0.24 is doubling as we speak... 0.36 is the VBS benchmark with a 
> comma-delimiter, 0.33 with a semicolon or other delimiter.
> 

anon@lowtide:~/code/dfs$ wc -l dfs_addresses_e
50000 dfs_addresses_e
anon@lowtide:~/code/dfs$ tail -n 20 dfs_addresses_e
Papa John's Pizza
RESTAURANTS PIZZA
1009 Athens Hwy Ste 8, Loganville, GA 30052 Call Now!
1.7 miwww.papajohns.com

Nagoya Japanese Steak House
RESTAURANTS STEAK HOUSES
2944 Rosebud Rd, Loganville, GA 30052 Call Now!
1.7 mi

My Pizza Buffet
RESTAURANTS PIZZA
2944 Rosebud Rd Ste D, Loganville, GA 30052 Call Now!
1.7 mi

Coopers Corner B&G
BARS
1111 Athens Hwy, Grayson, GA 30017 Call Now!
1.7 mi

anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ cat sortem3
#!/bin/bash

echo "Name;Street;CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
| sed -e 's/Call Now!//g' \
| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
| sed -e 's/;$//g' 

anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ cat sortem4
#!/bin/bash
echo "Name,Street,CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
| sed -e 's/Call Now!//g' \
| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
| sed -e 's/;$//g' \
| sed -e 's/,//g' \
| sed -e 's/;/,/g'

anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ time ./sortem3
Name;Street;CityStateZip
After The Game Sports Bar and Grill;2445 Moon Rd Ste 1; Grayson, GA 30017 
Burger King;1990 Grayson Hwy; Grayson, GA 30017 
Carlitos Mexican Restaurant, Inc;2445 Moon Rd; Grayson, GA 30017 
China Cafe;1911 Grayson Hwy; Grayson, GA 30017 
China Cafe;1911 Grayson Hwy Ste 4; Grayson, GA 30017 
Coopers Corner B&G;1111 Athens Hwy; Grayson, GA 30017 
Grand China Chinese Restaurant;910 Athens Hwy Ste O; Loganville, GA 30052 
Hail Mary Sports Pub;1950 Grayson Hwy Ste 140; Grayson, GA 30017 
Joa Wings and Deli;1911 Grayson Hwy; Grayson, GA 30017 
Joa Wings and Deli;1911 Grayson Hwy Ste 17; Grayson, GA 30017 
Johnny's Pizza;2023 Grayson Hwy Ste 110; Grayson, GA 30017 
KFC;1855 Grayson Hwy; Grayson, GA 30017 
Little Caesars Pizza;1950 Grayson Hwy; Grayson, GA 30017 
McDonald's;1881 Grayson Hwy; Grayson, GA 30017 
My Pizza Buffet;2944 Rosebud Rd Ste D; Loganville, GA 30052 
Nagoya Japanese Steak House;2944 Rosebud Rd; Loganville, GA 30052 
Pancake House;1911 Grayson Hwy; Grayson, GA 30017 
Pancake House;1911 Grayson Hwy Ste 5; Grayson, GA 30017 
Papa John's Pizza;1009 Athens Hwy Ste 8; Loganville, GA 30052 
Parkside Bakery & Cafe;2023 Grayson Hwy; Grayson, GA 30017 
Riverside Pizza;1845 Grayson Hwy Ste 1400; Grayson, GA 30017 
Taco Bell;1855 Grayson Hwy; Grayson, GA 30017 
Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052 
Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052 
Zaxby's;1931 Grayson Hwy; Grayson, GA 30017 

real	0m0.199s
user	0m0.236s
sys	0m0.016s
anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ time ./sortem4
Name,Street,CityStateZip
After The Game Sports Bar and Grill,2445 Moon Rd Ste 1, Grayson GA 30017 
Burger King,1990 Grayson Hwy, Grayson GA 30017 
Carlitos Mexican Restaurant Inc,2445 Moon Rd, Grayson GA 30017 
China Cafe,1911 Grayson Hwy, Grayson GA 30017 
China Cafe,1911 Grayson Hwy Ste 4, Grayson GA 30017 
Coopers Corner B&G,1111 Athens Hwy, Grayson GA 30017 
Grand China Chinese Restaurant,910 Athens Hwy Ste O, Loganville GA 30052 
Hail Mary Sports Pub,1950 Grayson Hwy Ste 140, Grayson GA 30017 
Joa Wings and Deli,1911 Grayson Hwy, Grayson GA 30017 
Joa Wings and Deli,1911 Grayson Hwy Ste 17, Grayson GA 30017 
Johnny's Pizza,2023 Grayson Hwy Ste 110, Grayson GA 30017 
KFC,1855 Grayson Hwy, Grayson GA 30017 
Little Caesars Pizza,1950 Grayson Hwy, Grayson GA 30017 
McDonald's,1881 Grayson Hwy, Grayson GA 30017 
My Pizza Buffet,2944 Rosebud Rd Ste D, Loganville GA 30052 
Nagoya Japanese Steak House,2944 Rosebud Rd, Loganville GA 30052 
Pancake House,1911 Grayson Hwy, Grayson GA 30017 
Pancake House,1911 Grayson Hwy Ste 5, Grayson GA 30017 
Papa John's Pizza,1009 Athens Hwy Ste 8, Loganville GA 30052 
Parkside Bakery & Cafe,2023 Grayson Hwy, Grayson GA 30017 
Riverside Pizza,1845 Grayson Hwy Ste 1400, Grayson GA 30017 
Taco Bell,1855 Grayson Hwy, Grayson GA 30017 
Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052 
Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052 
Zaxby's,1931 Grayson Hwy, Grayson GA 30017 

real	0m0.265s
user	0m0.292s
sys	0m0.040s
anon@lowtide:~/code/dfs$

[toc] | [prev] | [next] | [standalone]

#349759

From	DFS <nospam@dfs.com>
Date	2016-04-13 22:29 -0400
Message-ID	<nemv44$2ve$1@dont-email.me>
In reply to	#349755

On 4/13/2016 10:10 PM, owl wrote:

> anon@lowtide:~/code/dfs$ time ./sortem3
> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052


> anon@lowtide:~/code/dfs$ time ./sortem4
> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052



Di-dn't de-dupe.

[toc] | [prev] | [next] | [standalone]

#349766

From	owl <owl@rooftop.invalid>
Date	2016-04-14 02:36 +0000
Message-ID	<hjgud893.a90t34@rooftop.invalid>
In reply to	#349759

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 10:10 PM, owl wrote:
> 
>> anon@lowtide:~/code/dfs$ time ./sortem3
>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
> 
> 
>> anon@lowtide:~/code/dfs$ time ./sortem4
>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
> 
> 
> 
> Di-dn't de-dupe.
> 

Hmmm.  How'd that happen?  Anyway...

anon@lowtide:~/code/dfs$ cat sortem3
#!/bin/bash

echo "Name;Street;CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
| sed -e 's/Call Now!//g' \
| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
| sed -e 's/;$//g' \
| sort -u 
 

anon@lowtide:~/code/dfs$ cat sortem4
#!/bin/bash
echo "Name,Street,CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
| sed -e 's/Call Now!//g' \
| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
| sed -e 's/;$//g' \
| sed -e 's/,//g' \
| sed -e 's/;/,/g' \
| sort -u


anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ time ./sortem3
Name;Street;CityStateZip
After The Game Sports Bar and Grill;2445 Moon Rd Ste 1; Grayson, GA 30017 
Burger King;1990 Grayson Hwy; Grayson, GA 30017 
Carlitos Mexican Restaurant, Inc;2445 Moon Rd; Grayson, GA 30017 
China Cafe;1911 Grayson Hwy; Grayson, GA 30017 
China Cafe;1911 Grayson Hwy Ste 4; Grayson, GA 30017 
Coopers Corner B&G;1111 Athens Hwy; Grayson, GA 30017 
Grand China Chinese Restaurant;910 Athens Hwy Ste O; Loganville, GA 30052 
Hail Mary Sports Pub;1950 Grayson Hwy Ste 140; Grayson, GA 30017 
Joa Wings and Deli;1911 Grayson Hwy; Grayson, GA 30017 
Joa Wings and Deli;1911 Grayson Hwy Ste 17; Grayson, GA 30017 
Johnny's Pizza;2023 Grayson Hwy Ste 110; Grayson, GA 30017 
KFC;1855 Grayson Hwy; Grayson, GA 30017 
Little Caesars Pizza;1950 Grayson Hwy; Grayson, GA 30017 
McDonald's;1881 Grayson Hwy; Grayson, GA 30017 
My Pizza Buffet;2944 Rosebud Rd Ste D; Loganville, GA 30052 
Nagoya Japanese Steak House;2944 Rosebud Rd; Loganville, GA 30052 
Pancake House;1911 Grayson Hwy; Grayson, GA 30017 
Pancake House;1911 Grayson Hwy Ste 5; Grayson, GA 30017 
Papa John's Pizza;1009 Athens Hwy Ste 8; Loganville, GA 30052 
Parkside Bakery & Cafe;2023 Grayson Hwy; Grayson, GA 30017 
Riverside Pizza;1845 Grayson Hwy Ste 1400; Grayson, GA 30017 
Taco Bell;1855 Grayson Hwy; Grayson, GA 30017 
Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052 
Zaxby's;1931 Grayson Hwy; Grayson, GA 30017 

real	0m0.238s
user	0m0.260s
sys	0m0.032s
anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ time ./sortem4
Name,Street,CityStateZip
After The Game Sports Bar and Grill,2445 Moon Rd Ste 1, Grayson GA 30017 
Burger King,1990 Grayson Hwy, Grayson GA 30017 
Carlitos Mexican Restaurant Inc,2445 Moon Rd, Grayson GA 30017 
China Cafe,1911 Grayson Hwy, Grayson GA 30017 
China Cafe,1911 Grayson Hwy Ste 4, Grayson GA 30017 
Coopers Corner B&G,1111 Athens Hwy, Grayson GA 30017 
Grand China Chinese Restaurant,910 Athens Hwy Ste O, Loganville GA 30052 
Hail Mary Sports Pub,1950 Grayson Hwy Ste 140, Grayson GA 30017 
Joa Wings and Deli,1911 Grayson Hwy, Grayson GA 30017 
Joa Wings and Deli,1911 Grayson Hwy Ste 17, Grayson GA 30017 
Johnny's Pizza,2023 Grayson Hwy Ste 110, Grayson GA 30017 
KFC,1855 Grayson Hwy, Grayson GA 30017 
Little Caesars Pizza,1950 Grayson Hwy, Grayson GA 30017 
McDonald's,1881 Grayson Hwy, Grayson GA 30017 
My Pizza Buffet,2944 Rosebud Rd Ste D, Loganville GA 30052 
Nagoya Japanese Steak House,2944 Rosebud Rd, Loganville GA 30052 
Pancake House,1911 Grayson Hwy, Grayson GA 30017 
Pancake House,1911 Grayson Hwy Ste 5, Grayson GA 30017 
Papa John's Pizza,1009 Athens Hwy Ste 8, Loganville GA 30052 
Parkside Bakery & Cafe,2023 Grayson Hwy, Grayson GA 30017 
Riverside Pizza,1845 Grayson Hwy Ste 1400, Grayson GA 30017 
Taco Bell,1855 Grayson Hwy, Grayson GA 30017 
Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052 
Zaxby's,1931 Grayson Hwy, Grayson GA 30017 

real	0m0.232s
user	0m0.260s
sys	0m0.032s
anon@lowtide:~/code/dfs$

[toc] | [prev] | [next] | [standalone]

#349767

From	DFS <nospam@dfs.com>
Date	2016-04-13 22:42 -0400
Message-ID	<nemvt3$501$1@dont-email.me>
In reply to	#349759

On 4/13/2016 10:29 PM, DFS wrote:
> On 4/13/2016 10:10 PM, owl wrote:
>
>> anon@lowtide:~/code/dfs$ time ./sortem3
>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
>
>
>> anon@lowtide:~/code/dfs$ time ./sortem4
>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
>
>
>
> Di-dn't de-dupe.

* also didn't write a file out.

* looks like you're fudging by looking for 'mi' in line 4, instead of
   just deleting the entire line regardless of contents.

   sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \

* does sed not support an if-then, so you can run one script for
   all delimiters, rather than separate scripts?

[toc] | [prev] | [next] | [standalone]

#349770

From	owl <owl@rooftop.invalid>
Date	2016-04-14 03:07 +0000
Message-ID	<hjgie803.a3uixp3@rooftop.invalid>
In reply to	#349767

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 10:29 PM, DFS wrote:
>> On 4/13/2016 10:10 PM, owl wrote:
>>
>>> anon@lowtide:~/code/dfs$ time ./sortem3
>>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
>>> Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052
>>
>>
>>> anon@lowtide:~/code/dfs$ time ./sortem4
>>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
>>> Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052
>>
>>
>>
>> Di-dn't de-dupe.
> 
> 
> * also didn't write a file out.
> 

That's what '>' operator is for.  You really want me to do that and
time it?

anon@lowtide:~/code/dfs$ time ./sortem3 > out3

real	0m0.266s
user	0m0.324s
sys	0m0.012s
anon@lowtide:~/code/dfs$ time ./sortem4 > out4

real	0m0.266s
user	0m0.280s
sys	0m0.032s
anon@lowtide:~/code/dfs$

anon@lowtide:~/code/dfs$ wc -l out3
25 out3
anon@lowtide:~/code/dfs$ wc -l out4
25 out4
anon@lowtide:~/code/dfs$ tail -n 3 out3
Taco Bell;1855 Grayson Hwy; Grayson, GA 30017 
Thai Taste Restaurant;1009 Athens Hwy; Loganville, GA 30052 
Zaxby's;1931 Grayson Hwy; Grayson, GA 30017 
anon@lowtide:~/code/dfs$ tail -n 3 out4
Taco Bell,1855 Grayson Hwy, Grayson GA 30017 
Thai Taste Restaurant,1009 Athens Hwy, Loganville GA 30052 
Zaxby's,1931 Grayson Hwy, Grayson GA 30017 
anon@lowtide:~/code/dfs$ 


> * looks like you're fudging by looking for 'mi' in line 4, instead of
>   just deleting the entire line regardless of contents.
> 
>   sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
> 
> * does sed not support an if-then, so you can run one script for
>   all delimiters, rather than separate scripts?
> 

That's not "fudging."  It's pattern matching.  At that point in the
processing the file looks like this:

anon@lowtide:~/code/dfs$ ./sortem5 | tail -n 5
Riverside Pizza;RESTAURANTS PIZZA;1845 Grayson Hwy Ste 1400, Grayson, GA 30017 Call Now!;0.7 mi
Taco Bell;RESTAURANTS FAST FOOD;1855 Grayson Hwy, Grayson, GA 30017 Call Now!;0.7 miwww.tacobell.com
Thai Taste Restaurant;RESTAURANTS FAMILY STYLE;1009 Athens Hwy, Loganville, GA 30052 Call Now!;1.7 mi
Thai Taste Restaurant;RESTAURANTS FAMILY STYLE;1009 Athens Hwy, Loganville, GA 30052 Call Now!;1.7 miwww.subway.com
Zaxby's;RESTAURANTS FAMILY STYLE;1931 Grayson Hwy, Grayson, GA 30017 Call Now!;0.7 miwww.zaxbys.com
anon@lowtide:~/code/dfs$ 

After the step that strips the "miles," it looks like this:

anon@lowtide:~/code/dfs$ ./sortem6 | tail -n 5
Riverside Pizza;RESTAURANTS PIZZA;1845 Grayson Hwy Ste 1400, Grayson, GA 30017 Call Now!;
Taco Bell;RESTAURANTS FAST FOOD;1855 Grayson Hwy, Grayson, GA 30017 Call Now!;
Thai Taste Restaurant;RESTAURANTS FAMILY STYLE;1009 Athens Hwy, Loganville, GA 30052 Call Now!;
Thai Taste Restaurant;RESTAURANTS FAMILY STYLE;1009 Athens Hwy, Loganville, GA 30052 Call Now!;
Zaxby's;RESTAURANTS FAMILY STYLE;1931 Grayson Hwy, Grayson, GA 30017 Call Now!;
anon@lowtide:~/code/dfs$ 

anon@lowtide:~/code/dfs$ cat sortem5
#!/bin/bash

echo "Name;Street;CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
#| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
#| sed -e 's/Call Now!//g' \
#| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
#| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
#| sed -e 's/;$//g' \
#| sort -u 
 

anon@lowtide:~/code/dfs$ cat sortem6
#!/bin/bash

echo "Name;Street;CityStateZip"
sed -e 's/$/;/g'<dfs_addresses_e \
| sed -e 's/^;/WWWWW/g' \
| sed -z 's/\n//g' \
| sed -e 's/WWWWW/\n/g' \
| sort -u \
| sed -e 's/;$//g' \
| sed -e 's/;[0-9]*\.[0-9]* mi.*$/;/g' \
#| sed -e 's/Call Now!//g' \
#| sed -e 's/\(.*\),\(.*\),\(.*\)$/\1;\2,\3/g' \
#| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1;\3/g' \
#| sed -e 's/;$//g' \
#| sort -u 
 

anon@lowtide:~/code/dfs$

[toc] | [prev] | [next] | [standalone]

#349773

From	DFS <nospam@dfs.com>
Date	2016-04-13 23:56 -0400
Message-ID	<nen47p$fvg$1@dont-email.me>
In reply to	#349770

On 4/13/2016 11:07 PM, owl wrote:

> That's what '>' operator is for.  You really want me to do that and
> time it?

Just making sure your script does everything mine does.

Thanks for explanation.

Tomorrow I'll reboot over to Linux and run your sed against my 10000 
addresses and check the speed.

my system
i5-750
8GB DDR3
Win8.1Pro
Mint17.3

[toc] | [prev] | [next] | [standalone]

#349772

From	owl <owl@rooftop.invalid>
Date	2016-04-14 03:32 +0000
Message-ID	<fhjdi903.arfa@rooftop.invalid>
In reply to	#349767

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 10:29 PM, DFS wrote:
>> On 4/13/2016 10:10 PM, owl wrote:
>>
> 
> * does sed not support an if-then, so you can run one script for
>   all delimiters, rather than separate scripts?
> 
 
Oops.  Forgot this one.  So, before you whine...

anon@lowtide:~/code/dfs$ cat sortemd
#!/bin/bash

#!/bin/bash
case $1 in
 "|") #echo "|" 
 ./sortem3 | sed -e 's/;/|/g'
 ;;

 ";") #echo ";"
  ./sortem3
 ;;

 ",") #echo ","
 ./sortem3 | sed -e 's/,//g' |sed -e 's/;/,/g'
 ;;

 "#") #echo "#"
 ./sortem3 | sed -e 's/;/#/g'
 ;;

  *) exit
 ;;
esac

anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ time ./sortemd ';' > outsemi

real	0m0.286s
user	0m0.332s
sys	0m0.032s
anon@lowtide:~/code/dfs$ time ./sortemd '|' > outpipe

real	0m0.267s
user	0m0.316s
sys	0m0.012s
anon@lowtide:~/code/dfs$ time ./sortemd ',' > outcomma

real	0m0.259s
user	0m0.316s
sys	0m0.008s
anon@lowtide:~/code/dfs$ time ./sortemd '#' > outpound

real	0m0.261s
user	0m0.304s
sys	0m0.016s
anon@lowtide:~/code/dfs$ tail -n 1 outsemi
Zaxby's;1931 Grayson Hwy; Grayson, GA 30017 
anon@lowtide:~/code/dfs$ tail -n 1 outpipe
Zaxby's|1931 Grayson Hwy| Grayson, GA 30017 
anon@lowtide:~/code/dfs$ tail -n 1 outcomma
Zaxby's,1931 Grayson Hwy, Grayson GA 30017 
anon@lowtide:~/code/dfs$ tail -n 1 outpound
Zaxby's#1931 Grayson Hwy# Grayson, GA 30017 
anon@lowtide:~/code/dfs$

[toc] | [prev] | [next] | [standalone]

Page 1 of 10 [1] 2 3 … 10 Next page →

csiph-web

Fabian: 10,000 addresses processed in 0.53 seconds with VBScript

Contents

#349538 — Fabian: 10,000 addresses processed in 0.53 seconds with VBScript

#349642

#349689

#349690

#349696

#349707

#349712

#349721

#350038

#349705

#349714

#349723

#349733

#349755

#349759

#349766

#349767

#349770

#349773

#349772