From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:8:6d80::]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id aNdPBwmQiWAA+QAAgWs5BA (envelope-from ) for ; Wed, 28 Apr 2021 18:40:41 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id OCHgAgmQiWAPUQAAB5/wlQ (envelope-from ) for ; Wed, 28 Apr 2021 16:40:41 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id B614510896 for ; Wed, 28 Apr 2021 18:40:40 +0200 (CEST) Received: from localhost ([::1]:51362 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lbnEt-0006xA-Ox for larch@yhetil.org; Wed, 28 Apr 2021 12:40:39 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:57840) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lbnDF-0005lq-D8 for emacs-orgmode@gnu.org; Wed, 28 Apr 2021 12:38:57 -0400 Received: from ciao.gmane.io ([116.202.254.214]:47698) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lbnDD-0002eG-Ul for emacs-orgmode@gnu.org; Wed, 28 Apr 2021 12:38:57 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1lbnDB-0004d7-Sj for emacs-orgmode@gnu.org; Wed, 28 Apr 2021 18:38:53 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: emacs-orgmode@gnu.org From: Maxim Nikulin Subject: Re: bug#47885: [PATCH] org-table-import: Make it more smarter for interactive use Date: Wed, 28 Apr 2021 23:38:47 +0700 Message-ID: References: <87czuq9958.fsf@gmail.com> <8735vmelfs.fsf@nicolasgoaziou.fr> <87k0oyfj4y.fsf@gmail.com> <87im4h9irn.fsf@nicolasgoaziou.fr> <87zgxpwqa7.fsf@gmail.com> <875z07jx6n.fsf@nicolasgoaziou.fr> <87tunqby9a.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 In-Reply-To: <87tunqby9a.fsf@gmail.com> Content-Language: en-US Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: 28 X-Spam_score: 2.8 X-Spam_bar: ++ X-Spam_report: (2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FORGED_MUA_MOZILLA=2.309, FREEMAIL_FORGED_FROMDOMAIN=0.249, FREEMAIL_FROM=0.001, HEADER_FROM_DIFFERENT_DOMAINS=0.25, NICE_REPLY_A=-0.001, NML_ADSP_CUSTOM_MED=0.9, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1619628040; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=rGrb+7Va7YTBy1ux87JfT0DOQsX+34fjHZpYrVOU+l8=; b=nGTBBKF9DNIUEB3T9bLtQOm+7C52b3DwEYQjc5ivi+dcM8mIMKkey65yAPEAisNAajFJvc aJ2rQlvNbC8PURDoBfFA849sjS2sOlcHxy9Va3zrfGD2KYCe6lJu270iPUDu/bGqzIoaCv Vzabf+wqhPTnJPHxoIysotr9rAzposO7V9alNGHRQ05LlgZzDq/MPG/F6PKGfSk/hNBKFU +K5DnKNI63dfN5QhtJwucGsl5oYNF1COgF5iydWNVK+4v0XDW/ErElrmf4ykGBkeDQ6Y9W Ni0PNXaTjQ8oHWHEi8cYNGDALMjswDXFMLfrQLZKGTF353wdvA/vnk68Q+vPOQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1619628040; a=rsa-sha256; cv=none; b=TEoZsO8SfDIX0vYnSUDImlGkj9ElNyPHSxGh3idNi+tuREaS+3622Z2sUhItySlZ2WpVnV JJumnfPLuUTrz5ZjZ1OVy5Su1SpLfkmxhG9qUoBFcL4ovUUL+9ZIG3f3xmCf9Dh/R737lR PhFMwOVtvhUdylnygsHgBC9fNm5F5MtjeMqzntOPXOnDbLYdf1xgbHOct9a0eLTCob4aKE YyIjtfgUrBlyYc9M7MmsXimCFcy/WJQUPAMCI4xNHyrj9tlb6RWwScgJIWEhl+mlB3f/fP L3l2/s09ZOfBBqyp/CvqDCDH0xL2UlrBZYl+KXx/lpUMOcTw7zVTNz8XKaBBDg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -1.85 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: B614510896 X-Spam-Score: -1.85 X-Migadu-Scanner: scn0.migadu.com X-TUID: Xp/uR5TgcFq7 On 28/04/2021 15:37, Utkarsh Singh wrote: > +List of preferred separator (in order of preference): > +comma, TAB, semicolon, colon or SPACE. I will hardly be using this feature heavily, so I do not insist that the following must be taken into account. Just some considerations... There are locales where comma is used as decimal separator 23,5 (e.g. ru_RU.UTF-8). Office software and applications oriented to office users often use semicolon as field separator. There are still may be plenty of numbers with fractional part, so with commas. Likely ";" should be tried at first for such locales. However the same user may have enough CSV files that are really "comma separated", e.g. results of numerical simulation where localization is intentionally ignored, data obtained from some equipment, etc. Some files (e.g. downloaded bank statements) may be in legacy 8-bit encoding instead of UTF-8. As a result, sometimes the only convenient way is to try various options with interactive preview.