stripping out line breaks

Results 1 to 2 of 2

Thread: stripping out line breaks

  1. #1
    Join Date
    Dec 1969

    Default stripping out line breaks

    Hi,<BR><BR>User enters data into text box. Text inserted into db (SQL 2k). I then retrieve the data to email to someone. I need to strip out the carriage returns though (should the use have hit &#039;return&#039; when entering data into text box. Have tried all kinds of combinations .ie.<BR><BR>text = Replace(textValue, vbCRLF, "")<BR><BR>all to no avail.<BR>Question - how are returns encoded in SQL 2K?<BR><BR>Thanks, <BR>Dan<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: stripping out line breaks

    Try this:<BR>[code language="VBScript"]<BR>textValue = Replace(textValue, vbCRLF, "")<BR>textValue = Replace(textValue, vbCR, "")<BR>textValue = Replace(textValue, vbLF, "")<BR>[/code]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts