SoftadminUtil.String_ReduceWhitespace

 Show all Hide all

This function replaces all blocks of continuous whitespace within a string with a single space character. Also, any leading and trailing whitespace is trimmed.

List of ASCII-characters considered whitespace:
9 Horizontal tab
10 New line
11 Vertical tab
12 Form feed
13 Carriage return
32 Space

Type: Scalar function
Area of use: General use

Return value: nvarchar(max)

The trimmed string

Parameters:

@Str mandatory nvarchar(max)
The string to reduce