I need to strip out the CR and LF from a comment field before displaying it. How is this done?

I've tried:

comment = replace(comment,"CHAR(13)&CHAR(10)","")
comment = replace(comment,CHAR(13)&CHAR(10),"")
comment = replace(comment,"CHAR(13)"&"CHAR(10)","")
comment = replace(comment,"vbCRLF","")
comment = replace(comment,vbCRLF,"")

Nothing works... How is it done??

Thanks.

These are normally replaced with <br>'s if you are displaying the text. Is this what you are trying to do? If so this does it for me:

  Function DisplayMemo(theText)
    DisplayMemo = ""
    on error resume next
    DisplayMemo = CStr(theText)
    if (len(DisplayMemo) > 0) Then
      DisplayMemo = Replace(DisplayMemo, vbCrLf, "<br>", 1, -1, 1)
    end if
  End Function

If not im sure you can alter the function to do what you want it to do.
Additionaly - I wrap this function when inserting to the DB:

  Function StoreText(theText)
    StoreText = ""
    on error resume next
    StoreText = CStr(theText)
    if (len(StoreText) > 0) Then
      StoreText = Replace(StoreText, """", "&quot;", 1, -1, 1)
      StoreText = Replace(StoreText, "'", "''", 1, -1, 1)
      StoreText = Replace(StoreText, vbCrLf, "<BR>", 1, -1, 1)
    end if
  End Function

Wind is your friend
Matt
www.elitemarquees.com.au

I'm trying to store the comment in SQL without the CRLF. The reason this. I have a edit form that pulled the data from SQL, and using Javascript, it autofills the edit form.

The problem happens because of the javascript. When there's a linebreak from the CRLF, the Javascript bombs. :( So I figure, I'll just store the comment data without the CRLF.

I've got good news... I pretty much gave up and was going to look at a Javascript option, but I decided to try comment = replace(comment,vbCRLF,"") again and it worked....

mmmmm I dont get it.

IMO - If a user enters a line break (vbCRLF) and hits submit why would you replace it with an empty string? If I was a user of on your site and took the time to enter information, I would be annoyed coming back to see my linebreaks removed.

Wind is your friend
Matt
www.elitemarquees.com.au

I agree with Matt. If I were to follow the solution you have provided for this text:

This is the first line of my comment.
This is the second line of my comment.

When I go to write that back out to the browser it is going to look like this:

This is the first line of my comment.This is the second line of my comment.

Maybe I have misunderstood something?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

The reason I had to take the line breaks out was because when of Javascript.

I have this script that auto fills a form for editing purposes. Well when the Javascript saw the line break, it would bomb. Plus the comment is short so it won't really be an issue. The biggest problem I had was at the end of the comment, people would insert a line break.

Personally I would never do this with JS. You have highlighted one of the, IMO many reasons why. ASP does a fine job of populating forms...

My 2 cents worth:
mmmm, strange user behaviour. I dont experience people hitting enter after entering data into text areas. If I did I and wanted to get rid of this last carridge return i would strip it off before inserting it into the DB. I wouldnt ever recommend removing all of the returns like your replace syntax is sure to do.

Wind is your friend
Matt
www.elitemarquees.com.au