[Nottingham] Howto delete chars from midway into lines of text?

Martin martin at ml1.co.uk
Thu May 6 12:28:25 UTC 2010


OK...

> Hopefully an easy answer for this one:
> 
> Given a ".csv" file where all the items are all delimited as text, how
> can I delete the nth and nth+1 quotes to turn one column into non-text?

Making a brew has come up with a nice solution using "cut" on the source
csv file. Conveniently, all the fields are fixed width so I can just
knock out the irksome two bytes on each line.

But what if the fields /had been/ variable width?...


Cheers,
Martin

-- 
----------------
Martin Lomas
martin at ml1.co.uk
----------------



More information about the Nottingham mailing list