Remove weird space from xml node (xPath/xQuery)

0
votes

I'm using Web-Harvest to scrap a website and generate xml file with data.

I'm having ugly nodes like <name> </name>, using normalize-space() didn't help so I opened the file in Hex view, and I found it corresponds to 'c2a0'. I looked arround for a solution, but no one helped...

To sum up, what I want is to remove that weird space (using xquery or xpath1/2), so I can get an empty node <name/>

ps: the used encoding is 'iso-8859-1'

1
xmlxpathunicodexquery
Are you sure of the encoding? C2A0 is no-break space in UTF-8, which makes kind of sense. - forty-two
@forty-two, well, the html source is in 'iso-8859-1' and my config and xml settings are 'iso-8859-1'... and it gives the space you see here <name> </name> - Enissay

1 Answers

1
votes

You can use translate to remove certain characters. And utf8 c2a0 is the character U+00A0, hexadecimal 0xA0 is 160, so you can use codepoints-to-string(160) to get a string with the space.

Together:

translate(your node text, codepoints-to-string(160), "")