< Back
Document Subject: Remove Carriage return, line feed from text field
Hint Short Cut: Add this to your code & documentation to help you find this page.
http://#SingleLineText or http://A555F9/nn.nsf/ByAlias/SingleLineText

One database we work on feeds another database. This database requires single line of text with no carriage returns or line feed characters.




Linefeeds are stored as ascii character 13 and then ascii character 10.

I tried using the code

@replacesubstring(NewIntExtn; @char(13) : @char(10) ;"")

in the Input translation formula for the field but it did not work.

So I left it as

 @trim(NewIntExtn)

 

In the end I put in the query save lotusscript:

 'Remove linefeed in field NewIntExtn
tempNewIntExtn = source.FieldGetText("NewIntExtn")
While Instr(tempNewIntExtn, Chr(13))
 tempNewIntExtn = Left(tempNewIntExtn, Instr(tempNewIntExtn, Chr(13))-1) & "" &    Right(tempNewIntExtn, Len(tempNewIntExtn) - Instr(tempNewIntExtn, Chr(13)))
Wend
While Instr(tempNewIntExtn, Chr(10))
 tempNewIntExtn = Left(tempNewIntExtn, Instr(tempNewIntExtn, Chr(10))-1) & "" &  Right(tempNewIntExtn, Len(tempNewIntExtn) - Instr(tempNewIntExtn, Chr(10)))
Wend
Call source.fieldsettext("NewIntExtn", tempNewIntExtn)