SoftadminUtil.String_ReplaceNewLine

 Show all Hide all

This function replaces all commonly used line terminating characters (or combination of characters) with a string supplied by the user.

Characters considered line terminators:

  • Carriage return followed by a line feed (CR+LF)
  • Carriage return (CR)
  • Line feed (LF)
Type: Scalar function
Area of use: General use

Parameters:

@String mandatory nvarchar(max)
The string in which to replace line terminators
@Replacement mandatory nvarchar(max)
The string which replaces the line terminators