From debbugs-submit-bounces@debbugs.gnu.org Sat Sep 24 09:12:16 2016 Received: (at submit) by debbugs.gnu.org; 24 Sep 2016 13:12:16 +0000 Received: from localhost ([127.0.0.1]:34004 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bnmka-0006rQ-Ia for submit@debbugs.gnu.org; Sat, 24 Sep 2016 09:12:16 -0400 Received: from eggs.gnu.org ([208.118.235.92]:42779) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bnjVe-0006qH-EI for submit@debbugs.gnu.org; Sat, 24 Sep 2016 05:44:38 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bnjVY-0006ae-C7 for submit@debbugs.gnu.org; Sat, 24 Sep 2016 05:44:33 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.3 required=5.0 tests=BAYES_40, FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:34130) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bnjVY-0006aY-8w for submit@debbugs.gnu.org; Sat, 24 Sep 2016 05:44:32 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:33743) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bnjVX-0002uO-7b for bug-coreutils@gnu.org; Sat, 24 Sep 2016 05:44:32 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bnjVW-0006ZE-65 for bug-coreutils@gnu.org; Sat, 24 Sep 2016 05:44:31 -0400 Received: from mail-oi0-x234.google.com ([2607:f8b0:4003:c06::234]:33567) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bnjVW-0006Xp-0W for bug-coreutils@gnu.org; Sat, 24 Sep 2016 05:44:30 -0400 Received: by mail-oi0-x234.google.com with SMTP id r126so160240105oib.0 for ; Sat, 24 Sep 2016 02:44:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=3+2wx8CqV27VQgppQEImgPSia+02PLv376LI8X80Lck=; b=cHaOLEoxTqRkI2dxx+Up+4dfskE6ZQ5/KskqBsKluarOInM9ThtNDybNOR/cysmiKQ 231jpR0/m6l3OOShxqacJlcT6kyuXwFRgNS6z+wpk/CRhUe2DdJstpFyNrbQa2XZPZWQ NLM3QXG4I4mEq4QJlv1n7LKRchWrhtRRs5vT9NbG6Vek2TpbRVA3pJ2T6zv3qen7DHyH E1L15zfddhDaPx7/jJ38G+EnJmV+FZa/uee+piDQi+OXT8wQ4N3xQ6qVSX7F3qDzMSrQ bU3XfgDErgA/ZbQYNa1AfYJV2Jk0WW/npG8PaC7e3kQe/vPLoLe2V0lvCpUNedFb3XKI LVFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=3+2wx8CqV27VQgppQEImgPSia+02PLv376LI8X80Lck=; b=HxfKkuX9fvE+QcAUg9C+25YU5A3gIlxxwTFr7R8g/GeaWE4bdvRlJy+k7lULnrCqw4 NV5VAs5Vyj6wxrlSaIZnnLuucRJAquCEsrNpGjJuQfB3lDqrStHLWN2shJ1EgDOH+B6k YWnBYxl/9Qt8/DM2u+y/0D2O6z1dwkQqB5/xp9E9drpEyg1E5GwnKoLdSIPKVIgi8l9d OdcHqNW32kNuixAtZ/+ATFKjq6cbfPWdMx47Jk6FhOn+m8juijiqsY+L9eIpJUveZac2 gyjDTZu9VA463MURQFZ6V07+IVgVqHE4U+VVLYsnrQQ6g/4uIewySOVKmMcRvdRUO6vd +i8g== X-Gm-Message-State: AE9vXwMDD+/12CYaS9oIzjfE7kpv2wLMw3zV2EGLBYBVXBExSsGxoTMIFoHC3eKlpsFLAmUu1SPvnYM6xAnfMA== X-Received: by 10.202.195.3 with SMTP id t3mr16135351oif.44.1474710269012; Sat, 24 Sep 2016 02:44:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.71.81 with HTTP; Sat, 24 Sep 2016 02:44:28 -0700 (PDT) From: Jash Dave Date: Sat, 24 Sep 2016 15:14:28 +0530 Message-ID: Subject: Problem while sorting comma separated values using sort command. To: bug-coreutils@gnu.org Content-Type: multipart/alternative; boundary=001a1134e968bb3961053d3dbd15 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -3.8 (---) X-Debbugs-Envelope-To: submit X-Mailman-Approved-At: Sat, 24 Sep 2016 09:12:14 -0400 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.8 (---) --001a1134e968bb3961053d3dbd15 Content-Type: text/plain; charset=UTF-8 There is problem while sorting comma separated entries (specifically numbers). Even when the separator symbol is set to comma, it reads all following columns with numbers, and doesn't treats comma as separator between following numbers. If I use command: sort -t"," -k1 -n Example.csv Example.csv : 1,100,a,1,a 4,1000,d,4,c 3,1002,c,3,c 22,10,a,2,b Output: 1,100,a,1,a 22,10,a,2,b 3,1002,c,3,c 4,1000,d,4,c Expected: 1,100,a,1,a 3,1002,c,3,c 4,1000,d,4,c 22,10,a,2,b But it works with column 2 or 4, since there are no following numbers. Regards, Jash Dave. --001a1134e968bb3961053d3dbd15 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
There is problem while sorting comma separa= ted entries (specifically numbers). Even when the separator symbol is set t= o comma, it reads all following columns with numbers, and doesn't treat= s comma as separator between following numbers.

If I use comma= nd:
sort -t"," -k1 -n Example.csv

Example.csv :
1,10= 0,a,1,a
4,1000,d,4,c
3,1002,c,3,c
22,10,a,2,b

Output:=
1,100,a,1,a
22,10,a,2,b
3,1002,c,3,c
4,1000,d,4,c


<= /div>Expected:
1,100,a,1,a
3,1002,c,3,c
4,1000,d,4,c
22,10,a,2,= b

But it works with column 2 or 4, since there= are no following numbers.

Regards,
Jash Da= ve.

--001a1134e968bb3961053d3dbd15-- From debbugs-submit-bounces@debbugs.gnu.org Sat Sep 24 11:35:24 2016 Received: (at 24527) by debbugs.gnu.org; 24 Sep 2016 15:35:24 +0000 Received: from localhost ([127.0.0.1]:34599 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bnoz6-0003cU-3O for submit@debbugs.gnu.org; Sat, 24 Sep 2016 11:35:24 -0400 Received: from mout.kundenserver.de ([212.227.126.131]:54846) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bnoz3-0003cH-Hu for 24527@debbugs.gnu.org; Sat, 24 Sep 2016 11:35:21 -0400 Received: from [192.168.101.10] ([217.86.86.51]) by mrelayeu.kundenserver.de (mreue003) with ESMTPSA (Nemesis) id 0MKdqV-1bmRXS2ZZH-0022mG; Sat, 24 Sep 2016 17:35:13 +0200 Subject: Re: bug#24527: Problem while sorting comma separated values using sort command. To: Jash Dave , 24527@debbugs.gnu.org References: From: Bernhard Voelker Message-ID: Date: Sat, 24 Sep 2016 17:35:12 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:C5Y1xsN7uw+zpj6rBtA/89PPTZVUqlW+dRdBeIf4Fw3J+0sB1zF I0XjqoLF2pvFPiWEyzBMoxXE+oGSGxWi6TzJCs4V66YABr+dw5irxGwhGK2ZQhqi47F3Z+2 Dewzb6iWQE7GLsJsdKI5XCDKk7N/tpfy81+wVvaptI3WEf+tNKOlHFOm+FmV2EzCkTN8ECG /Hld23uTW2v4UNRQVTDrw== X-UI-Out-Filterresults: notjunk:1;V01:K0:BNeZcZbUKqY=:LP31dpmKj7d7Psgq+XK63u O+kSf2RQmK8n7MczClQBt/V9tU6Be3dmPdiuLncbrUpE6ailXsu1A2dVXF7AAVpklbD6mhrLF 2h8EHSJek/IHhiUO9D4vsB1VXRE6N9FE5DDZ5ohw16jD+Bd5W6eT2qq764CE+yM0M6aXpHenJ TMb4ZPRwDoGBaLlIlUF2rW0vPHk2qGwb9kSgWb+ThFjXskhfX15zWEWiYvcvCvcsgk+W8qRiX +7idlcabBeHeF16AvsdOx3Ta7mdtZUPffwcLTAP5L9+WEknoeW07hgrKaR7ohO7+1thF0OZch oGizcjbTEKi5oZ/BHsjewE8EPN3AaJFyHuNEmUAzd/RpyRX/7HiXi/SSZZHRM8rFLEW7h6SPv edbZjdBDp+rMY6zT3uVKYbgzDCi1jjOjIzmpDA4K6Uj86uPv5gkUYcLrOABGT8763r1sTxTlF bp1vlCmLllNTM7a3V8bGjcmq863adNmnAcEqN/5n9zmmcdVtRkohq7zQvPvotoOHUHdExE+8q 3WCtMrI6NSqmLIfZSXOWAhWqdziihb/++PBlZ9I+Bpxx+5ZGjB4/L/YksDECsQ2bTziNWPcgn 44rWcSfIthwApanhp2XHS+Us/A7Mw138UGgBTaP5XC+WvayEi9KlwgHDy2/LRZL6GYaqWr9gl 2qMGQSmfsexn6aV+gg8HUtSxAZ/MaEiHvvkwjRhfgS4Wdby5XBJQpY7BQ7D0xgWSfpY0dAHIQ zYKqd2W4RnKiUUr7 X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 24527 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.0 (/) tag 24527 notabug close 24527 stop On 09/24/2016 11:44 AM, Jash Dave wrote: > There is problem while sorting comma separated entries (specifically > numbers). Even when the separator symbol is set to comma, it reads all > following columns with numbers, and doesn't treats comma as separator > between following numbers. > > If I use command: > sort -t"," -k1 -n Example.csv > > Example.csv : > 1,100,a,1,a > 4,1000,d,4,c > 3,1002,c,3,c > 22,10,a,2,b > > Output: > 1,100,a,1,a > 22,10,a,2,b > 3,1002,c,3,c > 4,1000,d,4,c > > > Expected: > 1,100,a,1,a > 3,1002,c,3,c > 4,1000,d,4,c > 22,10,a,2,b > > But it works with column 2 or 4, since there are no following numbers. When having trouble with sort, usually the --debug option helps: $ sort --debug -t"," -k1 -n sort: using ‘en_US.UTF-8’ sorting rules sort: key 1 is numeric and spans multiple fields 1,100,a,1,a 4,1000,d,4,c 3,1002,c,3,c 22,10,a,2,b 1,100,a,1,a ______ ___________ 22,10,a,2,b ______ ___________ 3,1002,c,3,c _______ ____________ 4,1000,d,4,c _______ ____________ Aha, the key spans multiple fields. As you want to sort on the first field only, you need to tell sort to do so: $ sort --debug -t"," -k1,1 -n sort: using ‘en_US.UTF-8’ sorting rules 1,100,a,1,a 4,1000,d,4,c 3,1002,c,3,c 22,10,a,2,b 1,100,a,1,a _ ___________ 3,1002,c,3,c _ ____________ 4,1000,d,4,c _ ____________ 22,10,a,2,b __ ___________ Therefore, I'm marking this as not a bug in sort. Thanks & have a nice day, Berny From debbugs-submit-bounces@debbugs.gnu.org Sun Oct 28 02:36:57 2018 Received: (at control) by debbugs.gnu.org; 28 Oct 2018 06:36:57 +0000 Received: from localhost ([127.0.0.1]:46312 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gGegy-0006s5-Rb for submit@debbugs.gnu.org; Sun, 28 Oct 2018 02:36:56 -0400 Received: from mail-pl1-f173.google.com ([209.85.214.173]:44322) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1gGegx-0006rr-1Q for control@debbugs.gnu.org; Sun, 28 Oct 2018 02:36:55 -0400 Received: by mail-pl1-f173.google.com with SMTP id s5-v6so676150plq.11 for ; Sat, 27 Oct 2018 23:36:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:message-id:date:user-agent:mime-version:content-language :content-transfer-encoding; bh=j1UBGNHp0kaLt2ZEYHyNSc+dll9eBh+cHIBl7tG97+g=; b=jOpMyZlAZzCgrY+jhKI0nbwNn7SXEIqyOBm49AqF1p+lOQZb3Tze9S+zl6mzJQOzDw cD1GMGRXIrm94R+VyLXj5jfENdYL4sAk70KebqCF59er/4ACc1G+tGBPDuRcg9S4JD84 /G4/GXll9u8I7XppmW2QkpQWPsZaM1KxnJvDPnn9siaTpVewMgqjhZtlJ3eaLLIIA3P4 OX9U+YwLSEgiph+dvrqCzAykmD/cOtapgJjMactYCnVwXV+O8ASPkALjw4nwgmOlKsDn xvpYVoNyf2YbN+vZX5+uFZfl+Qb6Su1ago7HsjlQb8Mmb3zvyOuS5Al5ijjuqtbNXXQ1 RdxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:message-id:date:user-agent:mime-version :content-language:content-transfer-encoding; bh=j1UBGNHp0kaLt2ZEYHyNSc+dll9eBh+cHIBl7tG97+g=; b=UsWkuthu7JHTf23u18/FdRg99+o9zeEZYSD7/gQoy/DHUPLGBVkwVbCxlRMHUN15aV 29kEdcDOqpvV0DKu071QTHyAoDGpXh9I6N78tA2sm91frJ9TVKj0krUOoQlqPsm8zwIz C50eublE9NFfYooAD0pZG/Uhmmlw6ENa9ZAuGJEqbG/huh5b4yx19Lumf35479jaJleb ALnyyiwjHpviWSQ+hsJn6RyECxZ6rHL2RUwPbxilsE4sE98qezMtUaKvM35o1kls0S+A 48PNBZXDRpykP1psNLLSle2wWyBxRODzK6nr61LB1T7EoDREPqBkC4rcQb3TIAdIb386 nGXQ== X-Gm-Message-State: AGRZ1gIARrP1rJrBC1nf4Sot0/x8KdHt1UryrafHxbrnFGVZQoP1EO+z kIvYLD8McSN9SCf4Uw71e+KECTI2WVw= X-Google-Smtp-Source: AJdET5dRQc2UK8fHAs4Glw+FQBpE65GI5/8MswbdrU3S/nN32RhZUwRWVJ5M2YnRbEG+XBpsPLV4lQ== X-Received: by 2002:a17:902:b198:: with SMTP id s24-v6mr9133285plr.70.1540708608717; Sat, 27 Oct 2018 23:36:48 -0700 (PDT) Received: from tomato.housegordon.com (moose.housegordon.com. [184.68.105.38]) by smtp.googlemail.com with ESMTPSA id k24-v6sm17500077pfi.11.2018.10.27.23.36.47 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 27 Oct 2018 23:36:47 -0700 (PDT) To: control@debbugs.gnu.org From: Assaf Gordon Message-ID: Date: Sun, 28 Oct 2018 00:36:46 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Spam-Score: 2.0 (++) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: tags 24527 notabug close 24527 [...] Content analysis details: (2.0 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 FREEMAIL_FROM Sender email is commonly abused enduser mail provider (assafgordon[at]gmail.com) -0.0 SPF_PASS SPF: sender matches SPF record -0.0 RCVD_IN_DNSWL_NONE RBL: Sender listed at http://www.dnswl.org/, no trust [209.85.214.173 listed in list.dnswl.org] 1.8 MISSING_SUBJECT Missing Subject: header 0.2 NO_SUBJECT Extra score for no subject X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 1.0 (+) tags 24527 notabug close 24527 From unknown Sat Aug 16 21:19:56 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sun, 25 Nov 2018 12:24:06 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator