problem load with spaces

[Anonymous]

During Load I need to work with leading spaces.

TEST:

Load

' no class' as ABC,

*

resident xyz;

In this case I see the correct value with a leading space " no class"

When I need a pre.load, the leading spaces are dropped

TEST:

Load *,

Field1;

Load

' no class' as ABC

Field2

Resident xyz,

The same happens with Inline Tables.

TEST:

Load * inline [

A

' no class'

' test'

'another test'

2

];

The field A shows all text without leading space!

Why  Qlikview removes leading spaces during a pre-load or in an Inline table.

Can it be avoided? I need leading spaces!!

Qlikview 11 SR 5

Thanks for your help

[tresesco]

Try using text(), like:

Load

          Text(A) as A ;

Load * inline [

A

' no class'

' test'

'another test'

2

];

[Anonymous]

no change, the same behaviour

[#4 · Accepted solution]

Try putting

Set Verbatim = 1;

at the start of your load script

[its_anandrjs]

Update new check now

Write like below script

TEST:

LOAD *,Text(A) as TextA;

Load * inline [

A

' no class'

' test'

'another test'

2

];

And plot field TextA

[tresesco]

set Verbatim = 1;      in the script

[its_anandrjs]

Did you try Text(FieldName) it works for me

TEST:

LOAD *,Text(A) as TextA;

Load * inline [

A

' no class'

' test'

'another test'

2

];

See the output

[Anonymous]

it only works with "set Verbatim=1"

without that, the preleading spaces are removed

[#9]

Another way, instead Set Verbatim, is to use Hard Space Char(160). So, it should be like:

let vHardSpace = Chr(160)

;

Load * inline [

F1

$(vHardSpace)My text

]

;