normalize-space() - Be Clear where to use in SOA

normalize-space() - Be Clear where to use in SOA


normalize-space() - Performs remove unwanted spaces in a string . We know that but how it works internally.

Example : "      Hai       User             Weclome     you            "

Input String contains spaces in the front , last and middle also. I want to remove spaces in front,middle and last.

Note : normalize space will remove extra spaces in between words also and put only one character space.

normalize-space("      Hai       User             Weclome     you            ") ;


Ouput :    "Hai User Welcome you"


If you are looking for front and last to remove spaces use 

oraext:right-trim(oreaxt:left-trim("      Hai       User             Weclome     you            "));


Output : "Hai       User             Weclome     you"