From unknown Fri Jun 20 07:18:26 2025 X-Loop: help-debbugs@gnu.org Subject: bug#11900: Sort by month fails if not in first field or first position Resent-From: jim@smartots.com Original-Sender: debbugs-submit-bounces@debbugs.gnu.org Resent-CC: bug-coreutils@gnu.org Resent-Date: Tue, 10 Jul 2012 16:07:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 11900 X-GNU-PR-Package: coreutils X-GNU-PR-Keywords: To: 11900@debbugs.gnu.org X-Debbugs-Original-To: bug-coreutils@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.13419364053972 (code B ref -1); Tue, 10 Jul 2012 16:07:02 +0000 Received: (at submit) by debbugs.gnu.org; 10 Jul 2012 16:06:45 +0000 Received: from localhost ([127.0.0.1]:60355 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SocxV-00011v-9G for submit@debbugs.gnu.org; Tue, 10 Jul 2012 12:06:45 -0400 Received: from eggs.gnu.org ([208.118.235.92]:50074) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SoVAb-0003yZ-I4 for submit@debbugs.gnu.org; Tue, 10 Jul 2012 03:47:45 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SoV5M-0005IX-Dm for submit@debbugs.gnu.org; Tue, 10 Jul 2012 03:42:21 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-6.9 required=5.0 tests=BAYES_00,RCVD_IN_DNSWL_HI autolearn=unavailable version=3.3.2 Received: from lists.gnu.org ([208.118.235.17]:37618) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SoV5M-0005IS-AB for submit@debbugs.gnu.org; Tue, 10 Jul 2012 03:42:16 -0400 Received: from eggs.gnu.org ([208.118.235.92]:45798) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SoV5H-0008Hw-JO for bug-coreutils@gnu.org; Tue, 10 Jul 2012 03:42:15 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SoV5A-0005Gf-Lb for bug-coreutils@gnu.org; Tue, 10 Jul 2012 03:42:11 -0400 Received: from smtp203.iad.emailsrvr.com ([207.97.245.203]:44809) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SoV5A-0005G6-GV for bug-coreutils@gnu.org; Tue, 10 Jul 2012 03:42:04 -0400 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp30.relay.iad1a.emailsrvr.com (SMTP Server) with ESMTP id B66BA20382 for ; Tue, 10 Jul 2012 03:42:02 -0400 (EDT) X-Virus-Scanned: OK Received: from legacy20.wa-web.iad1a (legacy20.wa-web.iad1a.rsapps.net [192.168.2.206]) by smtp30.relay.iad1a.emailsrvr.com (SMTP Server) with ESMTP id A29E0202F2 for ; Tue, 10 Jul 2012 03:42:02 -0400 (EDT) Received: from smartots.com (localhost.localdomain [127.0.0.1]) by legacy20.wa-web.iad1a (Postfix) with ESMTP id 7753B3C70066 for ; Tue, 10 Jul 2012 03:42:02 -0400 (EDT) Received: by apps.rackspace.com (Authenticated sender: jim@smartots.com, from: jim@smartots.com) with HTTP; Tue, 10 Jul 2012 15:42:02 +0800 (HKT) Date: Tue, 10 Jul 2012 15:42:02 +0800 (HKT) From: jim@smartots.com MIME-Version: 1.0 Content-Type: text/plain;charset=UTF-8 Content-Transfer-Encoding: quoted-printable Importance: Normal X-Priority: 3 (Normal) X-Type: plain Message-ID: <1341906122.48755808@apps.rackspace.com> X-Mailer: webmail7.0 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-Received-From: 208.118.235.17 X-Spam-Score: -6.2 (------) X-Mailman-Approved-At: Tue, 10 Jul 2012 12:06:39 -0400 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.13 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -6.2 (------) =0A=0AIf I put a month in any column other than the first, at any position = than the first, sort fails-=0A=0A> echo -e "1 qFeb\n1 qJan" | sort -k2.2,2.= 5M=0A1 qFeb=0A1 qJan=0A=0AThe following all *DO* work, however:=0A=0A=0A#Fi= rst column, not first position=0A> echo -e "qFeb\nqJan" | sort -k1.2,1.5M= =0AqJan=0AqFeb=0A=0A#Second column, first position=0A> echo -e "1 Feb\n1 Ja= n" | sort -k2.1,2.4M=0A1 Jan=0A1 Feb=0A=0A#Second column, full key=0A> echo= -e "1 Feb\n1 Jan" | sort -k2M=0A1 Jan=0A1 Feb=0A From unknown Fri Jun 20 07:18:26 2025 X-Loop: help-debbugs@gnu.org Subject: bug#11900: Sort by month fails if not in first field or first position Resent-From: =?UTF-8?Q?P=C3=A1draig?= Brady Original-Sender: debbugs-submit-bounces@debbugs.gnu.org Resent-CC: bug-coreutils@gnu.org Resent-Date: Tue, 10 Jul 2012 17:17:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 11900 X-GNU-PR-Package: coreutils X-GNU-PR-Keywords: To: jim@smartots.com Cc: 11900@debbugs.gnu.org Received: via spool by 11900-submit@debbugs.gnu.org id=B11900.134194061610305 (code B ref 11900); Tue, 10 Jul 2012 17:17:02 +0000 Received: (at 11900) by debbugs.gnu.org; 10 Jul 2012 17:16:56 +0000 Received: from localhost ([127.0.0.1]:60495 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1Soe3T-0002g9-2x for submit@debbugs.gnu.org; Tue, 10 Jul 2012 13:16:55 -0400 Received: from mx1.redhat.com ([209.132.183.28]:43494) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1Soe3P-0002fx-PI; Tue, 10 Jul 2012 13:16:52 -0400 Received: from int-mx09.intmail.prod.int.phx2.redhat.com (int-mx09.intmail.prod.int.phx2.redhat.com [10.5.11.22]) by mx1.redhat.com (8.14.4/8.14.4) with ESMTP id q6AHBOt5028699 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 10 Jul 2012 13:11:24 -0400 Received: from [10.36.116.45] (ovpn-116-45.ams2.redhat.com [10.36.116.45]) by int-mx09.intmail.prod.int.phx2.redhat.com (8.14.4/8.14.4) with ESMTP id q6AHBHLT015946 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Tue, 10 Jul 2012 13:11:23 -0400 Message-ID: <4FFC6234.7060609@draigBrady.com> Date: Tue, 10 Jul 2012 18:11:16 +0100 From: =?UTF-8?Q?P=C3=A1draig?= Brady User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:6.0) Gecko/20110816 Thunderbird/6.0 MIME-Version: 1.0 References: <1341906122.48755808@apps.rackspace.com> In-Reply-To: <1341906122.48755808@apps.rackspace.com> X-Enigmail-Version: 1.3.2 Content-Type: text/plain; charset=UTF-8 X-Scanned-By: MIMEDefang 2.68 on 10.5.11.22 Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by mx1.redhat.com id q6AHBOt5028699 X-Spam-Score: -6.9 (------) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.13 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -6.9 (------) tag 11900 + notabug close 11900 stop On 07/10/2012 08:42 AM, jim@smartots.com wrote: > echo -e "1 qFeb\n1 qJan" | sort -k2.2,2.5M Yep that's a tricky one, but specified by POSIX. --debug is very useful here... $ echo -e "1 qFeb\n1 qJan" | sort --debug -k2.2,2.5M sort: using =E2=80=98en_US.utf8=E2=80=99 sorting rules sort: leading blanks are significant in key 1; consider also specifying '= b' 1 qFeb ^ no match for key ______ 1 qJan ^ no match for key ______ Now you might think you can just specify -b, but... $ echo -e "1 qFeb\n1 qJan" | sort --debug -b -k2.2,2.5M sort: using =E2=80=98en_US.utf8=E2=80=99 sorting rules sort: leading blanks are significant in key 1; consider also specifying '= b' sort: option '-b' is ignored 1 qFeb ^ no match for key ______ 1 qJan ^ no match for key ______ So you might then think you could add 'b' to the full key, but... $ echo -e "1 qFeb\n1 qJan" | sort --debug -b -k2.2,2.5Mb sort: using =E2=80=98en_US.utf8=E2=80=99 sorting rules sort: leading blanks are significant in key 1; consider also specifying '= b' 1 qFeb ^ no match for key ______ 1 qJan ^ no match for key ______ So what you really need to do is: $ echo -e "1 qFeb\n1 qJan" | sort --debug -k2.2b,2.5Mb sort: using =E2=80=98en_US.utf8=E2=80=99 sorting rules 1 qJan ___ ______ 1 qFeb ___ ______ cheers, P=C3=A1draig.