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 2 of 10 — ← Prev page 1 [2] 3 4 … 10 Next page →

#349774

From	DFS <nospam@dfs.com>
Date	2016-04-14 00:04 -0400
Message-ID	<nen4lr$h74$1@dont-email.me>
In reply to	#349772

On 4/13/2016 11:32 PM, owl wrote:
> 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$


Thanks.

Now it's time to do some taxes.  TaxAct online (which I used for years) 
is now trying to charge $15 just to import last year's return.  Bogus.

I'm trying 'freefilefillableforms', via irs.gov.

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

#349776

From	owl <owl@rooftop.invalid>
Date	2016-04-14 04:38 +0000
Message-ID	<hgjvmd93a.r3a@rooftop.invalid>
In reply to	#349774

DFS <nospam@dfs.com> wrote:
> On 4/13/2016 11:32 PM, owl wrote:
>> 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$
> 
> 
> Thanks.
> 
> Now it's time to do some taxes.

Oh shit!  Thanks.  

Fuck it.  I'll do it tomorrow.

>  TaxAct online (which I used for years) 
> is now trying to charge $15 just to import last year's return.  Bogus.
> 
> I'm trying 'freefilefillableforms', via irs.gov.
> 

I've used turbotax for some years now.  IIRC it's free for the fed.
Some small amount for the state.

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

#350124

From	Sandman <mr@sandman.net>
Date	2016-04-15 19:25 +0000
Message-ID	<sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>
In reply to	#349538

In article <nejanb$p7n$1@dont-email.me>, 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.

> 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 hobby ware.

Since I don't know the exact format they were supposed to be in, here's my 
entry:

~/Desktop/dfs> cat out.txt
cat: out.txt: No such file or directory
~/Desktop/dfs> wc -l addresses.txt 
  115438 addresses.txt
~/Desktop/dfs> wc -l process.pl 
      21 process.pl
~/Desktop/dfs> time ./process.pl
real	0m0.105s
user	0m0.096s
sys	0m0.006s
~/Desktop/dfs> cat out.txt 
Angelito's Restaurant,1441 E Fletcher Ave, Tampa, FL 33612 
Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612 
First Watch Restaurant Dls,2726 E Fowler Ave, Tampa, FL 33612 
Carribean Cuisine Restaurant,9714 N Nebraska Ave, Tampa, FL 33612 
Quiznos Sandwich Restaurants,10001 N Florida Ave, Tampa, FL 33612 
Ming Dou Chinese Restaurant,1120 E Fowler Ave, Tampa, FL 33612 
Caribbean Connections Restaurant & Bar,10509 N Nebraska Ave, Tampa, FL 33612
Gino's Bar & Restaurant,10006 N Armenia Ave, Tampa, FL 33612 
Checkers Drive-In Restaurant,1509 E Fowler Ave, Tampa, FL 33612 
Ronnie's Restaurant,10910 N 30th St Ste 101, Tampa, FL 33612 
Golden Touch Caribbean Restaurant & Bakery,9310 N Florida Ave, Tampa, FL 33612
A&W Restaurant,1707 E Fowler Ave, Tampa, FL 33612 
Ho Ho Choy Chinese Restaurant,1441 E Fletcher Ave Ste 125, Tampa, FL 33612 
Alsutan Restaurant,11150 N 30th St, Tampa, FL 33612 
Gino's Bar & Restaurant,10010 N Armenia Ave, Tampa, FL 33612

That's 21 lines of perl code running on a Macbook Air, doing it in 0.1 seconds.

-- 
Sandman

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

#350125

From	Sandman <mr@sandman.net>
Date	2016-04-15 19:37 +0000
Message-ID	<sandman-e39f840edc51a047f0faddfd013694b0@individual.net>
In reply to	#350124

In article <sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>, Sandman 
wrote:

> > DFS:
> > 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 hobby ware.
> 
> Since I don't know the exact format they were supposed to be in,
> here's my entry:

> ~/Desktop/dfs>cat out.txt
> cat: out.txt: No such file or directory
> ~/Desktop/dfs>wc -l addresses.txt
>  115438 addresses.txt
> ~/Desktop/dfs>wc -l process.pl
>  21 process.pl
> ~/Desktop/dfs>time ./process.pl
> real 0m0.105s
> user 0m0.096s>
> sys 0m0.006s
>
> That's 21 lines of perl code running on a Macbook Air, doing it in
> 0.1 seconds.

Oh yeah, and that's ten times as many addresses as well, I forgot to add. :)

-- 
Sandman

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

#350133

From	DFS <nospam@dfs.com>
Date	2016-04-15 16:17 -0400
Message-ID	<neri3f$ekl$1@dont-email.me>
In reply to	#350125

On 4/15/2016 3:37 PM, Sandman wrote:
> In article <sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>, Sandman
> wrote:
>
>>> DFS:
>>> 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 hobby ware.
>>
>> Since I don't know the exact format they were supposed to be in,
>> here's my entry:
>
>> ~/Desktop/dfs>cat out.txt
>> cat: out.txt: No such file or directory
>> ~/Desktop/dfs>wc -l addresses.txt
>>   115438 addresses.txt
>> ~/Desktop/dfs>wc -l process.pl
>>   21 process.pl
>> ~/Desktop/dfs>time ./process.pl
>> real 0m0.105s
>> user 0m0.096s>
>> sys 0m0.006s
>>
>> That's 21 lines of perl code running on a Macbook Air, doing it in
>> 0.1 seconds.
>
> Oh yeah, and that's ten times as many addresses as well, I forgot to add. :)

Your output isn't .csv compatible - you left a comma after the city:
Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612

Should be :

With , delimiter:
Name,Address,CityStateZip
Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612

With ; delimiter:
Name;Address;CityStateZip
Olive Garden Italian Restaurant;2801 E Busch Blvd;Tampa, FL 33612

21 lines of code is amazing.  owl did something similar with sed.

Not sure how many addresses you're starting with, or what data source, 
but the base input format is 5 lines per address block (as it comes from 
www.usdirectory.com).  Following is 25 addresses with one dupe in it.

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

After The Game Sports Bar and Grill
RESTAURANTS BARBECUE
2445 Moon Rd Ste 1, Grayson, GA 30017 Call Now!
0.3 mi

McDonald's
RESTAURANTS FAST FOOD
1881 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 miwww.mcdonalds.com

Zaxby's
RESTAURANTS FAMILY STYLE
1931 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 miwww.zaxbys.com

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

China Cafe
CAFES
1911 Grayson Hwy Ste 4, Grayson, GA 30017 Call Now!
0.7 mi

Hail Mary Sports Pub
BARS GRILLS & PUBS
1950 Grayson Hwy Ste 140, Grayson, GA 30017 Call Now!
0.7 mi

Burger King
RESTAURANTS FAST FOOD
1990 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 miwww.burgerking.com

Joa Wings and Deli
RESTAURANTS DELICATESSENS
1911 Grayson Hwy Ste 17, Grayson, GA 30017 Call Now!
0.7 mi

Parkside Bakery & Cafe
CAFES
2023 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 mi

Pancake House
RESTAURANTS FAMILY STYLE
1911 Grayson Hwy Ste 5, Grayson, GA 30017 Call Now!
0.7 mi

Johnny's Pizza
RESTAURANTS PIZZA
2023 Grayson Hwy Ste 110, Grayson, GA 30017 Call Now!
0.7 mi

Little Caesars Pizza
RESTAURANTS PIZZA
1950 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 miwww.littlecaesars.com

China Cafe
CAFES
1911 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 mi

Joa Wings and Deli
RESTAURANTS DELICATESSENS
1911 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 mi

Pancake House
RESTAURANTS FAMILY STYLE
1911 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 mi

KFC
RESTAURANTS CHICKEN
1855 Grayson Hwy, Grayson, GA 30017 Call Now!
0.7 miwww.kfc.com

Grand China Chinese Restaurant
RESTAURANTS FAMILY STYLE
910 Athens Hwy Ste O, 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

Thai Taste Restaurant
RESTAURANTS FAMILY STYLE
1009 Athens Hwy, Loganville, GA 30052 Call Now!
1.7 mi

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

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

#350136

From	Steve Carroll <fretwizzer@gmail.com>
Date	2016-04-15 13:33 -0700
Message-ID	<e8b886fe-0b22-483d-840f-b04570bcfbd7@googlegroups.com>
In reply to	#350133

On Friday, April 15, 2016 at 2:18:02 PM UTC-6, DFS wrote:
> On 4/15/2016 3:37 PM, Sandman wrote:
> > In article <sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>, Sandman
> > wrote:
> >
> >>> DFS:
> >>> 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 hobby ware.
> >>
> >> Since I don't know the exact format they were supposed to be in,
> >> here's my entry:
> >
> >> ~/Desktop/dfs>cat out.txt
> >> cat: out.txt: No such file or directory
> >> ~/Desktop/dfs>wc -l addresses.txt
> >>   115438 addresses.txt
> >> ~/Desktop/dfs>wc -l process.pl
> >>   21 process.pl
> >> ~/Desktop/dfs>time ./process.pl
> >> real 0m0.105s
> >> user 0m0.096s>
> >> sys 0m0.006s
> >>
> >> That's 21 lines of perl code running on a Macbook Air, doing it in
> >> 0.1 seconds.
> >
> > Oh yeah, and that's ten times as many addresses as well, I forgot to add. :)
> 
> 
> Your output isn't .csv compatible

???

> - you left a comma after the city:
> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
> 
> Should be :
> 
> With , delimiter:
> Name,Address,CityStateZip
> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612

Why wouldn't you want the city delimited in the file?

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

#350139

From	DFS <nospam@dfs.com>
Date	2016-04-15 16:59 -0400
Message-ID	<nerkhi$mld$1@dont-email.me>
In reply to	#350136

On 4/15/2016 4:33 PM, Steve Carroll wrote:

>> Your output isn't .csv compatible
>
> ???
>
>> - you left a comma after the city:
>> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
>>
>> Should be :
>>
>> With , delimiter:
>> Name,Address,CityStateZip
>> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
>
> Why wouldn't you want the city delimited in the file?


You could, but with his format, you're left with State and Zip lumped 
together.  It's strange.

The original mailing label Fabian showed had Name;Address;CityStateZip

That's more typical in my experience.

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

#350667

From	Steve Carroll <fretwizzer@gmail.com>
Date	2016-04-18 08:11 -0700
Message-ID	<aa5513b5-e66d-4014-83f7-4e2439aa1369@googlegroups.com>
In reply to	#350139

On Friday, April 15, 2016 at 2:59:42 PM UTC-6, DFS wrote:
> On 4/15/2016 4:33 PM, Steve Carroll wrote:
> 
> >> Your output isn't .csv compatible
> >
> > ???
> >
> >> - you left a comma after the city:
> >> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
> >>
> >> Should be :
> >>
> >> With , delimiter:
> >> Name,Address,CityStateZip
> >> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
> >
> > Why wouldn't you want the city delimited in the file?
> 
> 
> You could, but with his format, you're left with State and Zip lumped 
> together.  It's strange.
> 
> The original mailing label Fabian showed had Name;Address;CityStateZip
> 
> That's more typical in my experience.

IMO it's more useful to have each piece of data separated (how you output it is irrelevant).

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

#350675

From	DFS <nospam@dfs.com>
Date	2016-04-18 11:54 -0400
Message-ID	<nf2vpt$eub$1@dont-email.me>
In reply to	#350667

On 4/18/2016 11:11 AM, Steve Carroll wrote:
> On Friday, April 15, 2016 at 2:59:42 PM UTC-6, DFS wrote:
>> On 4/15/2016 4:33 PM, Steve Carroll wrote:
>>
>>>> Your output isn't .csv compatible
>>>
>>> ???
>>>
>>>> - you left a comma after the city: Olive Garden Italian
>>>> Restaurant,2801 E Busch Blvd, Tampa, FL 33612
>>>>
>>>> Should be :
>>>>
>>>> With , delimiter: Name,Address,CityStateZip Olive Garden
>>>> Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
>>>
>>> Why wouldn't you want the city delimited in the file?
>>
>>
>> You could, but with his format, you're left with State and Zip
>> lumped together.  It's strange.
>>
>> The original mailing label Fabian showed had
>> Name;Address;CityStateZip
>>
>> That's more typical in my experience.
>
> IMO it's more useful to have each piece of data separated (how you
> output it is irrelevant).

It's more useful for searching and sorting, but not for printing and 
reporting.

I've done enough of this to know what works best (in MS Access reporting
at least).  When City State and Zip are in separate fields on a report, 
the spacing often looks bad because of the number of characters in the 
city name:

Tucker,    GA  43243
Kalamazoo, MI  13236

So you combine them into one and make sure the field on the report is 
wide enough to display the longest:

Tucker, GA 43243
Kalamazoo, MI 13236

Then the addresses look right when they're printed on reports or envelopes.

Behind the scenes you want to store the data separately, of course.

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

#350911

From	owl <owl@rooftop.invalid>
Date	2016-04-20 00:19 +0000
Message-ID	<ghjje3a.03fa@rooftop.invalid>
In reply to	#350675

DFS <nospam@dfs.com> wrote:
> On 4/18/2016 11:11 AM, Steve Carroll wrote:
>> On Friday, April 15, 2016 at 2:59:42 PM UTC-6, DFS wrote:
>>> On 4/15/2016 4:33 PM, Steve Carroll wrote:
>>>
>>>>> Your output isn't .csv compatible
>>>>
>>>> ???
>>>>
>>>>> - you left a comma after the city: Olive Garden Italian
>>>>> Restaurant,2801 E Busch Blvd, Tampa, FL 33612
>>>>>
>>>>> Should be :
>>>>>
>>>>> With , delimiter: Name,Address,CityStateZip Olive Garden
>>>>> Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
>>>>
>>>> Why wouldn't you want the city delimited in the file?
>>>
>>>
>>> You could, but with his format, you're left with State and Zip
>>> lumped together.  It's strange.
>>>
>>> The original mailing label Fabian showed had
>>> Name;Address;CityStateZip
>>>
>>> That's more typical in my experience.
>>
>> IMO it's more useful to have each piece of data separated (how you
>> output it is irrelevant).
> 
> 
> It's more useful for searching and sorting, but not for printing and 
> reporting.
> 
> I've done enough of this to know what works best (in MS Access reporting
> at least).  When City State and Zip are in separate fields on a report, 
> the spacing often looks bad because of the number of characters in the 
> city name:
> 
> Tucker,    GA  43243
> Kalamazoo, MI  13236
> 
> So you combine them into one and make sure the field on the report is 
> wide enough to display the longest:
> 
> Tucker, GA 43243
> Kalamazoo, MI 13236
> 
> Then the addresses look right when they're printed on reports or envelopes.
> 
> Behind the scenes you want to store the data separately, of course.

As a human, I would rather read the first version, the one with the extra
spaces, and with columns lined up for easy reading.  Envelope addresses are
the USPS's responsibility, and I doubt that the machine that reads the
envelope cares one way or another about the whitespace.

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

#350140

From	owl <owl@rooftop.invalid>
Date	2016-04-15 21:02 +0000
Message-ID	<hngmvjbi30.af3@rooftop.invalid>
In reply to	#350136

Steve Carroll <fretwizzer@gmail.com> wrote:
> On Friday, April 15, 2016 at 2:18:02 PM UTC-6, DFS wrote:
>> On 4/15/2016 3:37 PM, Sandman wrote:
>> > In article <sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>, Sandman
>> > wrote:
>> >
>> >>> DFS:
>> >>> 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 hobby ware.
>> >>
>> >> Since I don't know the exact format they were supposed to be in,
>> >> here's my entry:
>> >
>> >> ~/Desktop/dfs>cat out.txt
>> >> cat: out.txt: No such file or directory
>> >> ~/Desktop/dfs>wc -l addresses.txt
>> >>   115438 addresses.txt
>> >> ~/Desktop/dfs>wc -l process.pl
>> >>   21 process.pl
>> >> ~/Desktop/dfs>time ./process.pl
>> >> real 0m0.105s
>> >> user 0m0.096s>
>> >> sys 0m0.006s
>> >>
>> >> That's 21 lines of perl code running on a Macbook Air, doing it in
>> >> 0.1 seconds.
>> >
>> > Oh yeah, and that's ten times as many addresses as well, I forgot to add. :)
>> 
>> 
>> Your output isn't .csv compatible
> 
> ???
> 
>> - you left a comma after the city:
>> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
>> 
>> Should be :
>> 
>> With , delimiter:
>> Name,Address,CityStateZip
>> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
> 
> Why wouldn't you want the city delimited in the file? 

His spec was to have three fields:  Name, Street, CityStateZip and allow
for either comma or semicolon as delimiter.  If you're using a comma
delimiter, you have to strip the comma between city and state or you
end up with four fields.

If it were my data, I would want everything separated, even state from
zip, in order to facilitate more query types.

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

#350322

From	Steve Carroll <fretwizzer@gmail.com>
Date	2016-04-16 08:05 -0700
Message-ID	<09e3a649-4cfe-45c1-8e2f-94a6cd8f44a5@googlegroups.com>
In reply to	#350140

On Friday, April 15, 2016 at 3:02:33 PM UTC-6, owl wrote:
> Steve Carroll <fretwizzer@gmail.com> wrote:
> > On Friday, April 15, 2016 at 2:18:02 PM UTC-6, DFS wrote:
> >> On 4/15/2016 3:37 PM, Sandman wrote:
> >> > In article <sandman-81c9fb86564f5573d013141b93d6cee2@individual.net>, Sandman
> >> > wrote:
> >> >
> >> >>> DFS:
> >> >>> 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 hobby ware.
> >> >>
> >> >> Since I don't know the exact format they were supposed to be in,
> >> >> here's my entry:
> >> >
> >> >> ~/Desktop/dfs>cat out.txt
> >> >> cat: out.txt: No such file or directory
> >> >> ~/Desktop/dfs>wc -l addresses.txt
> >> >>   115438 addresses.txt
> >> >> ~/Desktop/dfs>wc -l process.pl
> >> >>   21 process.pl
> >> >> ~/Desktop/dfs>time ./process.pl
> >> >> real 0m0.105s
> >> >> user 0m0.096s>
> >> >> sys 0m0.006s
> >> >>
> >> >> That's 21 lines of perl code running on a Macbook Air, doing it in
> >> >> 0.1 seconds.
> >> >
> >> > Oh yeah, and that's ten times as many addresses as well, I forgot to add. :)
> >> 
> >> 
> >> Your output isn't .csv compatible
> > 
> > ???
> > 
> >> - you left a comma after the city:
> >> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
> >> 
> >> Should be :
> >> 
> >> With , delimiter:
> >> Name,Address,CityStateZip
> >> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
> > 
> > Why wouldn't you want the city delimited in the file? 
> 
> His spec was to have three fields:  Name, Street, CityStateZip and allow
> for either comma or semicolon as delimiter.  If you're using a comma
> delimiter, you have to strip the comma between city and state or you
> end up with four fields.
> 
> If it were my data, I would want everything separated, even state from
> zip, in order to facilitate more query types.

Same here.

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

#350266

From	Sandman <mr@sandman.net>
Date	2016-04-16 08:56 +0000
Message-ID	<sandman-c122e9f93fc128fb97e388fac7df9552@individual.net>
In reply to	#350133

In article <neri3f$ekl$1@dont-email.me>, DFS wrote:

> > > Sandman:
> > > Since I don't know the exact format they were supposed to be in,
> > > here's my entry:
> > 
> > > ~/Desktop/dfs>cat out.txt
> > > cat: out.txt: No such file or directory
> > > ~/Desktop/dfs>wc -l addresses.txt
> > > 115438 addresses.txt
> > > ~/Desktop/dfs>wc -l process.pl
> > > 21 process.pl
> > > ~/Desktop/dfs>time ./process.pl
> > > real 0m0.105s
> > > user 0m0.096s>
> > > sys 0m0.006s
> > 
> > > That's 21 lines of perl code running on a Macbook Air, doing it
> > > in 0.1 seconds.
> > 
> > Oh yeah, and that's ten times as many addresses as well, I forgot
> > to add. :)
> 
> Your output isn't .csv compatible - you left a comma after the city:
> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612

> Should be :

> Name,Address,CityStateZip
> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612

Hence the "Since I don't know the exact format they were supposed to be in" 
part :)

Remodeling the actual text data is a walk in the park with perl, as you may 
already know.

> 21 lines of code is amazing.  owl did something similar with sed.

Piping through sed is pretty processor intensive though

> Not sure how many addresses you're starting with

I just copied one page, 15 addresses, and grew them into 150k lines of 
addresses.

> or what data source

Same as yours.

> but the base input format is 5 lines per address block (as
> it comes from www.usdirectory.com). Following is 25 addresses with
> one dupe in it.

Yup, I used the same source, but 15 (as that's the number of hits on one 
page, if I recall correctly.

Using your addresses, copied to a input file of 300k:

> wc -l addresses.txt 
  344998 addresses.txt
> time ./process.pl 
real	0m0.303s
user	0m0.290s
sys	0m0.009s
> wc -l out.txt 
      24 out.txt

I end up with 24 lines (i.e. your 25 addresses with one duplicate) and it 
takes perl 0.3 seconds to plow through more than 30 times as much data. If we 
compare it to your 10k rows, we get:

> wc -l addresses.txt 
    9998 addresses.txt
> time ./process.pl 
real	0m0.022s

A measly 0.02 seconds :)

Here's an example using PHP:

> wc -l addresses.txt 
    9998 addresses.txt
> wc -l process.php
      14 process.php
> time ./process.php
real	0m0.114s
user	0m0.090s
sys	0m0.021s
> cat out.txt 
Name;Address;City;Zip
"Carlitos Mexican Restaurant, Inc";"2445 Moon Rd";Grayson;"GA 30017"
"After The Game Sports Bar and Grill";"2445 Moon Rd Ste 1";Grayson;"GA 30017"
McDonald's;"1881 Grayson Hwy";Grayson;"GA 30017"
Zaxby's;"1931 Grayson Hwy";Grayson;"GA 30017"
"Riverside Pizza";"1845 Grayson Hwy Ste 1400";Grayson;"GA 30017"
"Taco Bell";"1855 Grayson Hwy";Grayson;"GA 30017"
"China Cafe";"1911 Grayson Hwy";Grayson;"GA 30017"
"Hail Mary Sports Pub";"1950 Grayson Hwy Ste 140";Grayson;"GA 30017"
"Burger King";"1990 Grayson Hwy";Grayson;"GA 30017"
"Joa Wings and Deli";"1911 Grayson Hwy";Grayson;"GA 30017"
"Parkside Bakery & Cafe";"2023 Grayson Hwy";Grayson;"GA 30017"
"Pancake House";"1911 Grayson Hwy";Grayson;"GA 30017"
"Johnny's Pizza";"2023 Grayson Hwy Ste 110";Grayson;"GA 30017"
"Little Caesars Pizza";"1950 Grayson Hwy";Grayson;"GA 30017"
KFC;"1855 Grayson Hwy";Grayson;"GA 30017"
"Grand China Chinese Restaurant";"910 Athens Hwy Ste O";Loganville;"GA 30052"
"Thai Taste Restaurant";"1009 Athens Hwy";Loganville;"GA 30052"
"Papa John's Pizza";"1009 Athens Hwy Ste 8";Loganville;"GA 30052"
"Nagoya Japanese Steak House";"2944 Rosebud Rd";Loganville;"GA 30052"
"My Pizza Buffet";"2944 Rosebud Rd Ste D";Loganville;"GA 30052"
"Coopers Corner B&G";"1111 Athens Hwy";Grayson;"GA 30017"

So that's 10k rows of addresses, with a 14 line php script taking 0.11 
seconds to process them all and output a correctly formed CSV file (I 
selected to separate the address, city and zip into different fields for 
clarity :)

-- 
Sandman

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

#350278

From	owl <owl@rooftop.invalid>
Date	2016-04-16 11:28 +0000
Message-ID	<ghnvjdki93.af@rooftop.invalid>
In reply to	#350266

Sandman <mr@sandman.net> wrote:
> In article <neri3f$ekl$1@dont-email.me>, DFS wrote:
> 
>> > > Sandman:
>> > > Since I don't know the exact format they were supposed to be in,
>> > > here's my entry:
>> > 
>> > > ~/Desktop/dfs>cat out.txt
>> > > cat: out.txt: No such file or directory
>> > > ~/Desktop/dfs>wc -l addresses.txt
>> > > 115438 addresses.txt
>> > > ~/Desktop/dfs>wc -l process.pl
>> > > 21 process.pl
>> > > ~/Desktop/dfs>time ./process.pl
>> > > real 0m0.105s
>> > > user 0m0.096s>
>> > > sys 0m0.006s
>> > 
>> > > That's 21 lines of perl code running on a Macbook Air, doing it
>> > > in 0.1 seconds.
>> > 
>> > Oh yeah, and that's ten times as many addresses as well, I forgot
>> > to add. :)
>> 
>> Your output isn't .csv compatible - you left a comma after the city:
>> Olive Garden Italian Restaurant,2801 E Busch Blvd, Tampa, FL 33612
> 
>> Should be :
> 
>> Name,Address,CityStateZip
>> Olive Garden Italian Restaurant,2801 E Busch Blvd,Tampa FL 33612
> 
> Hence the "Since I don't know the exact format they were supposed to be in" 
> part :)
> 
> Remodeling the actual text data is a walk in the park with perl, as you may 
> already know.
> 
>> 21 lines of code is amazing.  owl did something similar with sed.
> 
> Piping through sed is pretty processor intensive though
> 
>> Not sure how many addresses you're starting with
> 
> I just copied one page, 15 addresses, and grew them into 150k lines of 
> addresses.
> 
>> or what data source
> 
> Same as yours.
> 
>> but the base input format is 5 lines per address block (as
>> it comes from www.usdirectory.com). Following is 25 addresses with
>> one dupe in it.
> 
> Yup, I used the same source, but 15 (as that's the number of hits on one 
> page, if I recall correctly.
> 
> Using your addresses, copied to a input file of 300k:
> 
>> wc -l addresses.txt 
>   344998 addresses.txt
>> time ./process.pl 
> real    0m0.303s
> user    0m0.290s
> sys     0m0.009s
>> wc -l out.txt 
>       24 out.txt
> 
> I end up with 24 lines (i.e. your 25 addresses with one duplicate) and it 
> takes perl 0.3 seconds to plow through more than 30 times as much data. If we 
> compare it to your 10k rows, we get:
> 
>> wc -l addresses.txt 
>     9998 addresses.txt
>> time ./process.pl 
> real    0m0.022s
> 
> A measly 0.02 seconds :)
> 
> Here's an example using PHP:
> 
>> wc -l addresses.txt 
>     9998 addresses.txt
>> wc -l process.php
>       14 process.php
>> time ./process.php
> real    0m0.114s
> user    0m0.090s
> sys     0m0.021s
>> cat out.txt 
> Name;Address;City;Zip
> "Carlitos Mexican Restaurant, Inc";"2445 Moon Rd";Grayson;"GA 30017"
> "After The Game Sports Bar and Grill";"2445 Moon Rd Ste 1";Grayson;"GA 30017"
> McDonald's;"1881 Grayson Hwy";Grayson;"GA 30017"
> Zaxby's;"1931 Grayson Hwy";Grayson;"GA 30017"
> "Riverside Pizza";"1845 Grayson Hwy Ste 1400";Grayson;"GA 30017"
> "Taco Bell";"1855 Grayson Hwy";Grayson;"GA 30017"
> "China Cafe";"1911 Grayson Hwy";Grayson;"GA 30017"
> "Hail Mary Sports Pub";"1950 Grayson Hwy Ste 140";Grayson;"GA 30017"
> "Burger King";"1990 Grayson Hwy";Grayson;"GA 30017"
> "Joa Wings and Deli";"1911 Grayson Hwy";Grayson;"GA 30017"
> "Parkside Bakery & Cafe";"2023 Grayson Hwy";Grayson;"GA 30017"
> "Pancake House";"1911 Grayson Hwy";Grayson;"GA 30017"
> "Johnny's Pizza";"2023 Grayson Hwy Ste 110";Grayson;"GA 30017"
> "Little Caesars Pizza";"1950 Grayson Hwy";Grayson;"GA 30017"
> KFC;"1855 Grayson Hwy";Grayson;"GA 30017"
> "Grand China Chinese Restaurant";"910 Athens Hwy Ste O";Loganville;"GA 30052"
> "Thai Taste Restaurant";"1009 Athens Hwy";Loganville;"GA 30052"
> "Papa John's Pizza";"1009 Athens Hwy Ste 8";Loganville;"GA 30052"
> "Nagoya Japanese Steak House";"2944 Rosebud Rd";Loganville;"GA 30052"
> "My Pizza Buffet";"2944 Rosebud Rd Ste D";Loganville;"GA 30052"
> "Coopers Corner B&G";"1111 Athens Hwy";Grayson;"GA 30017"
> 
> So that's 10k rows of addresses, with a 14 line php script taking 0.11 
> seconds to process them all and output a correctly formed CSV file (I 
> selected to separate the address, city and zip into different fields for 
> clarity :)
> 

No source code + no initial file == bullshit.

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

#350391

From	Sandman <mr@sandman.net>
Date	2016-04-16 19:13 +0000
Message-ID	<sandman-0fdd14be3183c43d606ce11bfc7f7116@individual.net>
In reply to	#350278

In article <ghnvjdki93.af@rooftop.invalid>, owl wrote:

> No source code + no initial file == bullshit.

Do you want to see the addresses.txt file? You never showed us yours.

Here's the perl script:

#!/usr/bin/perl
use strict;
use warnings;
use 5.010;
#use Class::CSV;
$/ = "\n\n";
open my $fh, "<addresses.txt" or die;
open my $oh, ">out.txt" or die;
my (@o, @l);
while (<$fh>){
	chomp;
	s/Call now\!//mi;
	chop;
	@l = split "\n";
	my $f = $l[0] . "," . $l[2] . "\n";
	push @o, $f unless grep {$_ eq $f} @o;
}
foreach (sort keys @o){
	print $oh $o[$_];
}
close $fh;
close $oh;

And here's the PHP script:

#!/usr/bin/php
<?
	$fo = fopen("out.txt", "w");
	fputcsv($fo, ["Name", "Address", "City", "Zip"], ";");
	foreach (explode("\n\n", file_get_contents("addresses.txt")) as $part){
		$parts = explode("\n", $part);
		$parts[2] = str_replace(" Call Now!", "", $parts[2]);
		list ($address, $city, $zip) = explode(", ", $parts[2]);
		$out[$parts[0]] = [$parts[0], $address, $city, $zip];
	}
	foreach ($out as $key => $a){
		fputcsv($fo, $a, ";");
	}
	fclose($out);
?>

-- 
Sandman

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

#350401

From	owl <owl@rooftop.invalid>
Date	2016-04-16 21:12 +0000
Message-ID	<hgjdkie03.ag4@rooftop.invalid>
In reply to	#350391

Sandman <mr@sandman.net> wrote:
> In article <ghnvjdki93.af@rooftop.invalid>, owl wrote:
> 
>> No source code + no initial file == bullshit.
> 
> Do you want to see the addresses.txt file? You never showed us yours.
> 

I used DFS's posted file and dup'ed it to 10,000 records.

I couldn't get anything to happen with your php script.  You perl script
breaks one of the records which has an extra comma for Inc. (Carlitos
something or other).  Your script also doesn't do all of the processing
that was stipulated.

I shortened mine to duplicate your final (broken) result.  Mine requires
a final sort to strip off the dup.  I didn't modify your code to sort,
but when I pass your file through sort -u it results in zero diff.
Yours ends up being a tad slower on my machine, but prior to my final
sort yours is a tad faster, so ymmv.

anon@lowtide:~/code/dfs$ rm out.txt
anon@lowtide:~/code/dfs$ rm outsorted.txt
anon@lowtide:~/code/dfs$ rm outmine
anon@lowtide:~/code/dfs$ time ./sandman.pl;sort -u out.txt>outsorted.txt

real	0m0.133s
user	0m0.128s
sys	0m0.000s
anon@lowtide:~/code/dfs$ time ./sortx >outmine

real	0m0.120s
user	0m0.112s
sys	0m0.008s
anon@lowtide:~/code/dfs$ diff outsorted.txt outmine
anon@lowtide:~/code/dfs$ cat sortx
#!/bin/bash

sed -z 's/\n/;/g'<dfs_addresses_e \
| sed -e 's/;;/\n/g' \
| sort -u \
| sed -e 's/Call Now!.*//g' \
| sed -e 's/^\([^;]*\);\([^;]*\);\(.*\)$/\1,\3/g' \
| sort -u

anon@lowtide:~/code/dfs$
anon@lowtide:~/code/dfs$ head -n 3 outsorted.txt
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 
anon@lowtide:~/code/dfs$ 
anon@lowtide:~/code/dfs$ head -n 3 outmine
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 
anon@lowtide:~/code/dfs$

You can see above where the Carlitos record ends up with five fields
instead of four.

Here's how my original script (with a frontend to select delimiter)
handled that record:

anon@lowtide:~/code/dfs$ ./sortemdg ';' |grep Carlitos
Carlitos Mexican Restaurant, Inc;2445 Moon Rd; Grayson, GA 30017 
anon@lowtide:~/code/dfs$ ./sortemdg ',' |grep Carlitos
Carlitos Mexican Restaurant Inc,2445 Moon Rd, Grayson GA 30017 
anon@lowtide:~/code/dfs$

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

#350450

From	Sandman <mr@sandman.net>
Date	2016-04-17 08:51 +0000
Message-ID	<sandman-85f0be31b734ac677f7d2d38f18901c2@individual.net>
In reply to	#350401

In article <hgjdkie03.ag4@rooftop.invalid>, owl wrote:

> > > owl:
> > > No source code + no initial file == bullshit.
> > 
> > Sandman:
> > Do you want to see the addresses.txt file? You never showed us
> > yours.
> 
> I used DFS's posted file and dup'ed it to 10,000 records.

> I couldn't get anything to happen with your php script. You perl
> script breaks one of the records which has an extra comma for Inc.
> (Carlitos something or other). Your script also doesn't do all of
> the processing that was stipulated.

Hence the "I don't know what format you want..." in my earlier post, since the 
supposed stipulated processing wasn't part of the post I was responding to. 
Needlesstosay, formatting the data prior to output would add exactly nothing to 
the processing time. 

> You can see above where the Carlitos record ends up with five fields
> instead of four.

That's because a CSV output requirement was not known to me at the time. Use 
the PHP script and it's properly CSV formatted. 

> Here's how my original script (with a frontend to select delimiter)
> handled that record:

> anon@lowtide:~/code/dfs$ ./sortemdg ';' |grep Carlitos
> Carlitos Mexican Restaurant, Inc;2445 Moon Rd; Grayson, GA 30017 
> anon@lowtide:~/code/dfs$ ./sortemdg ',' |grep Carlitos
> Carlitos Mexican Restaurant Inc,2445 Moon Rd, Grayson GA 30017 
> anon@lowtide:~/code/dfs$

Well, that sucks. You shouldn't remove data, you should enclose it. Here's how 
it should look:

~> ./process.php
~> grep Carlitos out.txt
"Carlitos Mexican Restaurant, Inc","2445 Moon Rd",Grayson,"GA 30017"

~> ./process.php \;
~> grep Carlitos out.txt
"Carlitos Mexican Restaurant, Inc";"2445 Moon Rd";Grayson;"GA 30017"

-- 
Sandman

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

#350487

From	owl <owl@rooftop.invalid>
Date	2016-04-17 14:43 +0000
Message-ID	<ghdkif.ifae4@rooftop.invalid>
In reply to	#350450

Sandman <mr@sandman.net> wrote:
> In article <hgjdkie03.ag4@rooftop.invalid>, owl wrote:
> 
> 
>> Here's how my original script (with a frontend to select delimiter)
>> handled that record:
> 
>> anon@lowtide:~/code/dfs$ ./sortemdg ';' |grep Carlitos
>> Carlitos Mexican Restaurant, Inc;2445 Moon Rd; Grayson, GA 30017 
>> anon@lowtide:~/code/dfs$ ./sortemdg ',' |grep Carlitos
>> Carlitos Mexican Restaurant Inc,2445 Moon Rd, Grayson GA 30017 
>> anon@lowtide:~/code/dfs$
> 
> Well, that sucks. You shouldn't remove data, you should enclose it.

That's true.
What do you think is the problem with the php script not working
at all on my end?

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

#350489

From	Sandman <mr@sandman.net>
Date	2016-04-17 15:16 +0000
Message-ID	<sandman-f661726cce1474ada020e1e7d367c014@individual.net>
In reply to	#350487

In article <ghdkif.ifae4@rooftop.invalid>, owl wrote:

> > Sandman:
> > Well, that sucks. You shouldn't remove data, you should enclose
> > it.
> 
> That's true.
> What do you think is the problem with the php script not working
> at all on my end?

No idea, what version PHP do you use? Not that I'm using any fancy new stuff 
though.

sandman@Fantasy ~/Desktop/dfs> php -v
PHP 5.5.30 (cli) (built: Oct 23 2015 17:21:45) 
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies

sandman@Fantasy ~/Desktop/dfs> which php
/usr/bin/php

Maybe your php is somewhere else and you have to change the shebang? Maybe you 
forgot to make it executable? What error messages are you getting?

Do you have "." in your include path Otherwise you'd have to specify that 
entire paths to the in and out files?

sandman@Fantasy  ~/Desktop/dfs> php -i | grep php.ini
Configuration File (php.ini) Path => /etc
Loaded Configuration File => /etc/php.ini

andman@Fantasy  ~/Desktop/dfs> grep ^include_path /etc/php.ini
include_path = ".:/usr/share/php:/Atlas/Core/include/"

(never mind the Atlas thing, that's my CMS)

-- 
Sandman

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

#350494

From	owl <owl@rooftop.invalid>
Date	2016-04-17 16:10 +0000
Message-ID	<fhjdo02.afr@rooftop.invalid>
In reply to	#350489

Sandman <mr@sandman.net> wrote:
> In article <ghdkif.ifae4@rooftop.invalid>, owl wrote:
> 
>> > Sandman:
>> > Well, that sucks. You shouldn't remove data, you should enclose
>> > it.
>> 
>> That's true.
>> What do you think is the problem with the php script not working
>> at all on my end?
> 
> No idea, what version PHP do you use? Not that I'm using any fancy new stuff 
> though.
> 
> sandman@Fantasy ~/Desktop/dfs> php -v
> PHP 5.5.30 (cli) (built: Oct 23 2015 17:21:45) 
> Copyright (c) 1997-2015 The PHP Group
> Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
> 
> sandman@Fantasy ~/Desktop/dfs> which php
> /usr/bin/php
> 
> Maybe your php is somewhere else and you have to change the shebang? Maybe you 
> forgot to make it executable? What error messages are you getting?
> 
> Do you have "." in your include path Otherwise you'd have to specify that 
> entire paths to the in and out files?
> 
> sandman@Fantasy  ~/Desktop/dfs> php -i | grep php.ini
> Configuration File (php.ini) Path => /etc
> Loaded Configuration File => /etc/php.ini
> 
> andman@Fantasy  ~/Desktop/dfs> grep ^include_path /etc/php.ini
> include_path = ".:/usr/share/php:/Atlas/Core/include/"
> 
> (never mind the Atlas thing, that's my CMS)
> 

anon@lowtide:~/code/usenet$ php -v
PHP 5.6.19-0+deb8u1 (cli) (built: Mar 14 2016 10:22:33) 
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
anon@lowtide:~/code/usenet$ which php
/usr/bin/php
anon@lowtide:~/code/usenet$ php -i |grep php.ini
Configuration File (php.ini) Path => /etc/php5/cli
Loaded Configuration File => /etc/php5/cli/php.ini
anon@lowtide:~/code/usenet$ 

Include path was commented out.
Fixed that:

anon@lowtide:~/code/usenet$ grep ^include_path /etc/php5/cli/php.ini
include_path = ".:/usr/share/php"
anon@lowtide:~/code/usenet$ 

Still does nothing but echo the php even when input and output
file names are changed to full path.

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

Page 2 of 10 — ← Prev page 1 [2] 3 4 … 10 Next page →

csiph-web

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

Contents

#349774

#349776

#350124

#350125

#350133

#350136

#350139

#350667

#350675

#350911

#350140

#350322

#350266

#350278

#350391

#350401

#350450

#350487

#350489

#350494