replacing carriage returns?

Jerome · Jan 31, 2005

Hi, I know this is an old question but I don't find the solution on the
'net ...

The user enters his data into a multiline textarea field.
The data is saved in a TEXT field in a database on a SQL Server.
I want to display that data now, but the carriage returns should be
replaced with <br>! Otherwise the text doesn't have paragraphs.

How do I do that?

This hasn't worked:
<% response.write replace(rsRappAct.Fields.Item("texte").Value, Chr(13),
"<BR>")%>

Thanks a lot!

Jerome

larrybud2002 · Jan 31, 2005

Jerome said:
Hi, I know this is an old question but I don't find the solution on the
'net ...

The user enters his data into a multiline textarea field.
The data is saved in a TEXT field in a database on a SQL Server.
I want to display that data now, but the carriage returns should be
replaced with <br>! Otherwise the text doesn't have paragraphs.

How do I do that?

This hasn't worked:
<% response.write replace(rsRappAct.Fields.Item("texte").Value, Chr(13),
"<BR>")%>

don't use Chr(13), use

vbcrLF

McKirahan · Jan 31, 2005

Jerome said:
Hi, I know this is an old question but I don't find the solution on the
'net ...

The user enters his data into a multiline textarea field.
The data is saved in a TEXT field in a database on a SQL Server.
I want to display that data now, but the carriage returns should be
replaced with <br>! Otherwise the text doesn't have paragraphs.

How do I do that?

This hasn't worked:
<% response.write replace(rsRappAct.Fields.Item("texte").Value, Chr(13),
"<BR>")%>

Thanks a lot!

Jerome

<% Response.Write Replace(rsRappAct("texte"),vbCrLf,"<br>")%>

Somewhat off-topic but may be of interest ....

Here's an example of a client-side textarea cleanup I use.

It removes all leading and trailing CrLf's and spaces.

It also converts 3 or more CrLf's to just two.

<html>
<head>
<title>CrLf_Fix.htm</title>
<script type="text/javascript">
function CrLf() {
var rex1 = /^[\r\n\s*]+|[\r\n\s*]+$/g; // trim CrLf's
var rex2 = /(\r\n\s*){2,}/g; // 2max CrLf's
var data = document.forms[0].data.value;
if (data != "") {
var what;
//* remove leading and trailing CrLf's from "textarea":
what = data.replace(rex1,"");
//* replace 3+ consecutive CrLf's with 2 in "textarea":
what = what.replace(rex2,"\r\n\r\n");
if (what != data) document.forms[0].data.value = what;
}
}
</script>
</head>
<body>
<form>
<textarea name="data" cols="52" rows="20"></textarea>
<br>
<input type="button" value="Remove leading, trailing, and multiple CrLf's"
onclick="CrLf()">
<input type="reset" value="Clear">
</form>
</body>
</html>

It's not perfect (suggestions are welcome) but it helps reduce garbage
input.

Displaying carriage returns in a memo field	4	Aug 26, 2005
Carriage Returns	1	Oct 15, 2004
I dont get this. Please help me!!	2	Jan 24, 2023
Remove Carriage Returns	3	Apr 27, 2005
Replacing text, fails totally	1	Jul 7, 2010
Datagrid, formatting, carriage returns	6	Dec 15, 2005
preserving carriage returns	8	Nov 1, 2005
Can't get carriage returns in div	5	Jun 22, 2006

replacing carriage returns?

Jerome

larrybud2002

McKirahan

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads