Define the delimiter in a text file

[mark]

Following on from my previous post about connecting to a pipe delimted text file. I tried to print out the recordset fields using

response.write rs.fields(0).value

this has printed out every bit of text up to the first comma. So it thinks I am using a comma separated text file.

Is there any way of defining what delimiter to use, I need to use pipe (|) delimited.

I know this is a really tricky one but I am limited on what I can do because i have to use this pipe delimited text file.

Thanks