Carriage Return Problem

[smnbin]

Hello,

I have written some code which extracts data from a MySQL database and stores
it in a CSV file using CFFILE.

However, the database includes data inserted from an HTML textarea form
element which is stored in a MySQL text field. The textarea data includes
carriage returns which, when written to a CSV file, force a new line which
makes the data messy.

Is there a way of removing the carriage returns?

Many thanks,

Simon

[jdeline]

Use the Replace( ) function to get rid of your CR characters. Then place a CR at the end of each line before you write it as a CSV file.

<CFSET myText = Replace(myText, Chr(13), "", "ALL")>

[smnbin]

jdeline,

Thank you for your response. However, I tried the following code, but a new
line is still being forced in the CSV file.

<cfset GetEndOfProgrammeEvaluationForms.c8 =
Replace(GetEndOfProgrammeEvaluationForms.c8,Chr(13 ),"","ALL")>

Any further ideas would be very much appreciated.

Simon

[smnbin]

jdeline,

I tried the following, but it didn't work. I don't think my regular expression
is correct.

<cfset GetEndOfProgrammeEvaluationForms.c8 =
REReplace(GetEndOfProgrammeEvaluationForms.c8,"Chr (10)|Chr(13)","All")>

Any ideas?

Many thanks,

Simon

[Dan Bracuk]

I recently had to deal with a similar situation. The differences are:
1. My file is pipe delimited.
2. My source data comes from a vendor application, not an html form.

The following code worked for me.

<cffile action="write" nameconflict="overwrite"
addnewline="no" output=""
file="d:\dw\dwweb\work\#CaseFileName#">

<cfoutput query="casedata">
<cffile action="append"
file="d:\dw\dwweb\work\#CaseFileName#"
output="#caseid#|strip a bunch of fields|#theatre_mcase#|#Replace(pre_op_diag,
chr(10), ' ', 'all')##chr(13)#">
</cfoutput>

[MikerRoo]

You would use:
<cfset GetEndOfProgrammeEvaluationForms.c8 = REReplace (GetEndOfProgrammeEvaluationForms.c8, "", "", "All")>

[smnbin]

MikerRoo - that has fixed the problem.

Thank you very much for your help.

smnbin