topic Re: How can I read a single character SPACE in XML file? in QlikView

How can I read a single character SPACE in XML file?

Fri, 21 Feb 2014 12:29:12 GMT

I am trying to read different separators from an xml language file.

This works fine for all characters except for the case when space shall be separator. Note that here is a white space between the <sv> </sv> tags.

	<row>
	<key>SepSetting</key>
	<comment>1 character separator "translated" according to language</comment>
	<eng>,</eng>
	<sv> </sv>

</row>

When this is loaded in qlikview the field is emptied i.e the space-character is removed, i'm guessing some trimming has occurred.

Is there any way to state the space to make qlikview keep it when loading the xml-file?

I've tried with different ' 'and " " and also with some ascii and hex coding for "Space" as value, without any success.

Thanks!

/Anneh

Re: How can I read a single character SPACE in XML file?

Gysbert_Wassenaar — Fri, 21 Feb 2014 16:41:56 GMT

Add this to your script before the load statement:

set Verbatim = 1;

It will prevent stripping spaces. You may want to reset it afterwards to 0.

Re: How can I read a single character SPACE in XML file?

Sat, 22 Feb 2014 20:42:22 GMT

Use Verbatim function

Verbatim

Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters.

Example:

set Verbatim = 1;