From mboxrd@z Thu Jan 1 00:00:00 1970 From: Samuel Wales Subject: [OT] CSV to Org Date: Tue, 22 Nov 2011 15:56:33 -0700 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:54791) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RSzGV-00061F-Og for emacs-orgmode@gnu.org; Tue, 22 Nov 2011 17:56:36 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1RSzGU-0007NQ-IU for emacs-orgmode@gnu.org; Tue, 22 Nov 2011 17:56:35 -0500 Received: from mail-iy0-f169.google.com ([209.85.210.169]:52357) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RSzGU-0007NL-FU for emacs-orgmode@gnu.org; Tue, 22 Nov 2011 17:56:34 -0500 Received: by iaek3 with SMTP id k3so1134472iae.0 for ; Tue, 22 Nov 2011 14:56:33 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org I have an old CSV that looks like this. I'd like to convert it to Org format. I think I want to use properties for every field except Name (headline) and Note (body text with \r\n meaning newline). What is the best way to do this? "Na&me","&W","&H","A","B","N&et","&File","&Title","&Org","Addr&1","C&i","&St","&Zip","Addr&2","&Pc","&Note","gp","a&k","g&c","&Do","g&a" "some name something","823-2323","233-2323 as a a a a as","2323 something","","2323 fax? 3333 fax!","soao-sss.ss","","","","","","","","","",0,0,0,0,0 "bob and sylvia whosit","","","","","sylvia@sssssss.stanford.edu","","","","","","ca","","","","friend sss\r\nwwwww\r\nzsdddddd\r\nwwww\r\n",0,0,0,0,0 ... More generally, I wonder if there is a general mechanism, as I imagine this (with variations) is pretty common. I am aware of the table importer. Thanks.