RE: CSV File parsing

["Denis Povshedny" <denikin@...>]

Hi all,

here is my 2cents. :)

==========================
local fcsv, errmsg = io.open ( "csvImport.txt", "r" )
assert( fcsv, errmsg )
local data = fcsv:read( "*a" )
fcsv:close()

-- remove spaces, todo: add tab replacement
data = string.gsub( data, " ", "" )

-- transform start/end of lines
data = "{" .. string.gsub( data, "\n", "},\n{" ) .. "}"

-- process NULLs
local nRepl = 0
repeat
	data, nRepl = string.gsub( data, "{,", "{nil," )
until nRepl == 0
repeat
	data, nRepl = string.gsub( data, ",}", ",nil}" )
until nRepl == 0
repeat
	data, nRepl = string.gsub( data, ",,", ",nil," )
until nRepl == 0

-- wrap and run
local csv = assert( loadstring( "return {\n" .. data .. "}" ) ) () 
==========================

Multiple reassign is ineffective; the same way as loading entire file
may be not acceptable in all cases. 
I used it for make code more illustrative. But for small files it works
fine, :=) see attachments for detail.


-----Original Message-----
From: lua-bounces@bazar2.conectiva.com.br
[mailto:lua-bounces@bazar2.conectiva.com.br] On Behalf Of D Burgess
Sent: Thursday, July 20, 2006 5:01 AM
To: Lua list
Subject: Re: CSV File parsing


How do we handle non-existent values?

t = {1,,3,,5,,7,8}

I have always wished that the parser handled this.

DB

Attachment: csvImport.zip
Description: Zip compressed data