I don't recall how to regexprepl all occurences with one pass, but using a
script lang like tcl w/sed:
## Repeat using a do while to change from CSV to oeSV:
set newdata [exec sed -e s/","/oe/ << $data]
##
##Then:
set listdata [split $newdata oe]
##
--
To unsubscribe: mail [EMAIL PROTECTED] w
On Tue, 18 Jan 2000, Gate wrote:
> I need to do the following two things (separately):
>
> First.. I have a file with comma delineated fields. The data in each field
> is enclosed in double quotes ("). However, some data fields have a quote
> within the quotes, and I need to remove that. What
At 02:40 PM 1/18/00 -0800, Gate wrote:
>I need to do the following two things (separately):
>
>First.. I have a file with comma delineated fields. The data in each field
>is enclosed in double quotes ("). However, some data fields have a quote
>within the quotes, and I need to remove that. What is
Charles,
Ouch! You dream bigger than I did. :-)
You are correct in that my script doesn't address your example.
I'd say that kind of data is "Unintelligable(word?)" and needs
to be "Re-CSV'd".
Don't get me wrong, I'm not running from it, I just want "Real Data"
before investing that kind of time
Hi Rick
*if* this guys data is really CSV, then by definition, the ',' is the
field delimiter. In order to allow ',' characters in the filed data, the
data can be enclosed in '"' characters. I don't think they are required
though in his data it sounds like all fields are enclosed in '"' chars.
An
> First.. I have a file with comma delineated fields. The data in each field
> is enclosed in double quotes ("). However, some data fields have a quote
> within the quotes, and I need to remove that. What is my best choice for
> this?
As Alan said, this is CSV. If you can tell me how many fields
Bryan,
Don't listen to those perl guys... ;-)
See below
On Tue, 18 Jan 2000, Gate wrote:
=> I need to do the following two things (separately):
=>
=> First.. I have a file with comma delineated fields. The data in each field
=> is enclosed in double quotes ("). However, some data fields have a