Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

Tags (2)
2 Replies

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

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.


talk is cheap, supply exceeds demand
Not applicable

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

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;

Community Browser