cfhttp error "Invalid column header"

[SangLe]

I got a very simple csv file name "test.csv" which has
from,to,email
test,test,"test,test"

My code
<cfhttp name="get_file" url="test.csv" method="get" delimiter=","
textqualifier=""""></cfhttp>

I kept getting invalid column header error and if I enter textqualifier as =
"", then I run into a diff. error
"Incorrect number of columns in row", this only occur if I have a comma in one
of my colum but it will work fine if my email column only have one value. This
is why I was hoping to use textqaulifier to solve the problem but I can't seem
to get it working. Any one have any suggestions or ideas of how I can read
this type of format using cfhttp? Thanks.

[Stressed_Simon]

You should use cffile to read files off your own server. Then just treat the file as a string and use the relevant functions and loops to get what you want from the file!

[SangLe]

OK, I use your suggestion and it almost there, I was able to separate the list
with return characters but now the problem is the row data, e.g.
test,test,"test,test2",test

What function do I use to tell CF that there are only 4 items on this list, it
will be 5 if I use comma as delimeter, any suggestions?