From lojban+bncCK7Yk5CUCxDK4ofsBBoEVomD5A@googlegroups.com Thu Mar 17 04:32:46 2011 Received: from mail-vx0-f189.google.com ([209.85.220.189]) by chain.digitalkingdom.org with esmtp (Exim 4.72) (envelope-from ) id 1Q0BRY-0008Um-0S; Thu, 17 Mar 2011 04:32:46 -0700 Received: by vxc33 with SMTP id 33sf829913vxc.16 for ; Thu, 17 Mar 2011 04:32:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=beta; h=domainkey-signature:x-beenthere:received-spf:mime-version:date :message-id:subject:from:to:x-original-sender :x-original-authentication-results:reply-to:precedence:mailing-list :list-id:x-google-group-id:list-post:list-help:list-archive:sender :list-subscribe:list-unsubscribe:content-type; bh=GgUnDKj8/iL0N1mInYM4/bo9M7gsHeNzQzSwfZjIq2M=; b=AHiGVJkiiY/F1oIRTuDbQ/gPga3DFiS11HW901tmZZ5Pf6kiUJsoMAnzj23UVKazgU COvzb1QcwkyaYYOfvlsmIRvlPXal9Qg1XNeLTjiOQKySP6V3o9Q6IcIOzDg4XV12+3d8 SLbSz4eou5iYA468CRpc/EWCaE9LyztZC+VcQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlegroups.com; s=beta; h=x-beenthere:received-spf:mime-version:date:message-id:subject:from :to:x-original-sender:x-original-authentication-results:reply-to :precedence:mailing-list:list-id:x-google-group-id:list-post :list-help:list-archive:sender:list-subscribe:list-unsubscribe :content-type; b=Fkl8tDU/bvgD3vQ9d6wF5d/KO9Eg2olKOLxGypVZuryFe9s7SppxmYnj6pajDAJfa6 VJlrhTyoWRQsS031oWn6nNpICdkl4U8KgFXurTUyjGRddPo7blTzmdqrDzbKiOGJkPNV h6TXvxpTU39YiEnKlT/ObHYIss/aTk8etwtXg= Received: by 10.220.193.77 with SMTP id dt13mr168425vcb.9.1300361546551; Thu, 17 Mar 2011 04:32:26 -0700 (PDT) X-BeenThere: lojban@googlegroups.com Received: by 10.220.100.195 with SMTP id z3ls1023704vcn.2.p; Thu, 17 Mar 2011 04:32:25 -0700 (PDT) Received: by 10.220.123.134 with SMTP id p6mr354358vcr.0.1300361545394; Thu, 17 Mar 2011 04:32:25 -0700 (PDT) Received: by 10.220.123.134 with SMTP id p6mr354357vcr.0.1300361545374; Thu, 17 Mar 2011 04:32:25 -0700 (PDT) Received: from mail-qw0-f45.google.com (mail-qw0-f45.google.com [209.85.216.45]) by gmr-mx.google.com with ESMTPS id l8si187807vcs.2.2011.03.17.04.32.25 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 17 Mar 2011 04:32:25 -0700 (PDT) Received-SPF: pass (google.com: domain of rdentato@gmail.com designates 209.85.216.45 as permitted sender) client-ip=209.85.216.45; Received: by qwj8 with SMTP id 8so2340450qwj.4 for ; Thu, 17 Mar 2011 04:32:25 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.3.146 with SMTP id 18mr940464qcn.191.1300361545014; Thu, 17 Mar 2011 04:32:25 -0700 (PDT) Received: by 10.229.67.139 with HTTP; Thu, 17 Mar 2011 04:32:24 -0700 (PDT) Date: Thu, 17 Mar 2011 12:32:24 +0100 Message-ID: Subject: [lojban] jbovlaste xml to csv From: Remo Dentato To: lojban X-Original-Sender: rdentato@gmail.com X-Original-Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of rdentato@gmail.com designates 209.85.216.45 as permitted sender) smtp.mail=rdentato@gmail.com; dkim=pass (test mode) header.i=@gmail.com Reply-To: lojban@googlegroups.com Precedence: list Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com List-ID: X-Google-Group-Id: 1004133512417 List-Post: , List-Help: , List-Archive: Sender: lojban@googlegroups.com List-Subscribe: , List-Unsubscribe: , Content-Type: text/plain; charset=ISO-8859-1 Just in case could be of any use to somebody, I whipped up a quick script to convert XML jbovlaste dump (the lojban -> xxx direction) to a CSV file to be imported into OpenOffice (or Excel, or for any other use). ---8<----- cut here ---8<----- cut here ---8<----- cut here ---8<----- cut here ---8<----- ! gema script to convert jbovlaste XML dump to a CSV file ! 2011 Remo Dentato (rdentato@gmail.com) ! Visit http://gema.sourceforge.net to download gema for your OS \A="type"\;"official"\;"rafsi1"\;"rafsi2"\;"rafsi3"\;"valsi"\;"definition"\;"note" \=$1 ?= vls:\A=@set{w;}@set{t;}@set{d;}@push{r;\;}@push{r;\;}@push{r;\;}@set{n;}@set{x;"y"} vls:word\="*"=@set{w;"$1"} vls:type\=""=@set{t;"$1"} vls:\*\<\/rafsi\>=@push{r;"$1"\;} vls:\\<\/definition\>=@set{d;"$1"} vls:\\<\/notes\>=@set{n;"$1"} vls:?= vls:\<\/valsi\>=$t\;$x\;$r@pop{r}$r@pop{r}$r$w\;$d\;$n\n@terminate nsc:\;=, nsc:\n\r= nsc:"='' nsc:\n= typ:experimental =@set{x;"n"} typ:cmavo cluster=cluster cut here ---8<----- cut here ---8<----- cut here ---8<----- cut here ---8<----- cut here ---8<----- remod -- You received this message because you are subscribed to the Google Groups "lojban" group. To post to this group, send email to lojban@googlegroups.com. To unsubscribe from this group, send email to lojban+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/lojban?hl=en.