Hi,
Not sure what you are asking? Do you want to know how to get rid off
the quote characters?
If so, just do this on the line that is read in:
replace quote with empty in myCSVLine
Then just break off all the fields using "," as the delimiter as in:
put item 1 of myCSVLine into myNameOfField1
put item 2 of myCSVLine into myNameOfField2
put item 3 of myCSVLine into myNameOfField3
Hope this helps
All the Best
Dave
On 22 Jun 2007, at 23:11, Viktoras Didziulis wrote:
In cases like this I usually open the csv with my OpenOffice and
save it
with record delimiter set to tab and no text delimiter (e.g.
ordinary tab
delimited file). Then I go to my Revolution studio :-). Otherwise
it is a
real headache to process the "correct" csv files as some "clever"
programs
also put quotes around text strings only and don't put quotes
around numbers
etc, etc...
You can also load that real csv into mysql and then get it out as tab
delimited. SQLite might also be of some help - just put it into the
db and
get it back with select *.
Viktoras
-------Original Message-------
From: [EMAIL PROTECTED]
Date: 06/23/07 00:36:15
To: [email protected]
Subject: reading CSV text file
Hi,
i have to read a textfile, which is comma separated and contains "
as text
identifier. The item delimiter is ,
My problem is, i do not know, how can i read the file and detect
each item
of a line, as the items are sepearated by comma and the textfield/
items
could contain comma, too. How can i tell Revolution to ignore the
comma in
the "tesxtarea of an item"
Heres an example line
"7722"," ","Fuji Cleaning Cartridge fr DLT Streamer, retail","DLT
Reinigungskassette fr bis zu 20 Reinigungen nicht fr DLT 1 und
VS!","","",
BAND","183","Diverse Hersteller","42419",
31.03,38.79,35.27,34.48,34.48,34.48
32.66,0.000,0.000,"",24
As you can see, some fields/items are included in " ,others (the
numeric
values) are not. The field included in " could contain , .
Any idea, how i can solve that. I have to mention that in the
textfields/items there could be also the " as product description
e.g. TFT
19" or HDD 2.5"
Regards,
Matthias
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
