escaping double quotes in a cfparam

[TechDude]

Hi all,
I am creating a comma delimited file to be imported into excel.

I need the text of the fields to be double quoted.

the following code creates the file by concatenating the values of the form fields submitted by a form

<cfparam default=&quot;&quot; name=&quot;temp_output&quot; type=&quot;string&quot;>
<cfloop index=&quot;fname&quot; list=&quot;#form.fieldnames#&quot; >
<cfset temp_output = temp_output & #evaluate(&quot;form.&quot; & fname)#&&quot;,&quot;>
</cfloop>
<cfoutput>#removechars(temp_output,len(temp_output),1)#</cfoutput>

<cffile file=&quot;D:\utilities\testing.xls&quot; action=&quot;append&quot; output=&quot;#removechars(temp_output,len(temp_output),1)#&quot; >

the following snippet from the previous code is where I have the issue

<cfset temp_output = temp_output & #evaluate(&quot;form.&quot; & fname)#&&quot;,&quot;>

I need the output of #evaluate(&quot;form.&quot; & fname)# to be double quoted

is there a way to escape double quotes?
if so I could do something like this
<cfset temp_output = temp_output & &quot;(escapechar)&quot;&quot;&&quot;#evaluate(&quot;form.&quot; & fname)#&&quot;(escapechar)&quot;&quot;&&quot;,&quot;>


any help would be most appreciated

Chris Sorel
chris@exnihilo.com

http://www.exnihilo.com

Remember, If you continue to do what you have always done,

you will continue to get what you have always gotten.

 

[swilliams]

I thought you could use Chr(34)?? So you can do something like:

<cfset temp_output = temp_output & #Chr(34)# & #evaluate(&quot;form.&quot; & fname)# & #Chr(34)# & &quot;,&quot;>

NOTE: Not tested

Simon

 

[iza]

not tested either, but how about trying \&quot; ?

 

[TechDude]

Thanks,
The chr(34) worked.

Chris Sorel
chris@exnihilo.com

http://www.exnihilo.com

Remember, If you continue to do what you have always done,

you will continue to get what you have always gotten.