How to count spaces at the beginning of each row?

[ferranpuchol]

Hi everyone,

I need to count how many space characters are at the beginning of every row, but qv automatically deletes them.

How can I do it?

Thanks for your answer.

Ferran.

[jvitantonio]

Hi, you can use this function

substringcount(yourField, ' ')

[ferranpuchol]

I doesn't work, it returns 0. QV automatically deletes the spaces from the beginning of the load and i need to not do this.

Any other solution?

[Gysbert_Wassenaar · Accepted solution]

You need to set the Verbatim variable to 1 to prevent Qlikview from stripping the spaces. In the script you can add this line to prevent the trimming:

set Verbatim = 1;

[ferranpuchol]

Thanks!!!!