Query text file with paragraph entries

[dinoviapangea]

I have the following pipe delimited text file called temp.txt ,


name|date|comment
"John Doe"|"22-Apr-08 10:21"|"This is a text file entry.

This is a new paragraph in the comment field."


I'm trying to query it with the following query,

<cfhttp method="Get"
url="file_path/temp.txt"
name="Get_Data"
columns="name,date,comment"
textqualifier=""""
delimiter="|">

I keep getting incorrect number of columns in row. I believe it thinks the new paragraph is a new entry, but I thought the textqualifier would resolve this. Any help would be appreciated.

Thanks,
Dino

 

[FALCONSEYE]

could you try this?
textqualifier="#chr(13)##chr(10)#"

http://www.jetansolutions.com

 

[dinoviapangea]

Didn't work. I still get the same error. I thought for sure TEXTQUALIFIER="""" would work. Any other suggestions.

Thanks,
Dino