XQuery: removing newline/return character from end of a string stored in a variable in query

xquery flwor functx
Arvind picture Arvind · Sep 19, 2012 · Viewed 9.7k times · Source

How do I remove a new-line/return from the end of a variable? I tried functx:substring-before-last to try and remove the new line (denoting it as \r, \n and also as \r\n) but still when I output that variable's value, the newline is still there in it.

Answer

Leo Wörteler picture Leo Wörteler · Sep 19, 2012

You can either use fn:normalize-space($arg as xs:string?) to remove all additional whitespace:

Summary: Returns the value of $arg with whitespace normalized by stripping leading and trailing whitespace and replacing sequences of one or more than one whitespace character with a single space, #x20.

Or you can just use fn:replace(..) and a regular expression:

fn:replace($string, '(\r?\n|\r)$', '')

Related questions

xquery beginner- how to use an if-then-else within a FLWOR statement

I want to extract some content from a web page's XML equivalent, using XQuery. Here, I want to use if-then-else -- if a specific condition is met, then one value is returned by the xquery expression, otherwise a different value …

Read More
How can I query a value in SQL Server XML column

I have following XML stored in a XML column (called Roles) in a SQL Server database. <root> <role>Alpha</role> <role>Beta</role> <role>Gamma</role> &…

Read More
Concatenate multiple node values in xpath

I have a XML that looks like this <element1> <element2> <element3> <element4>Hello</element4> <element5>World</element5> </element3> <element3> <element4>…

Read More