topic How to insert Blanks in a string? in QlikView

How to insert Blanks in a string?

Wed, 18 Jul 2012 07:29:31 GMT

Does anybody know if exists a function to insert a caracter N times into a String?

to do something like that:

'COUNTRY:' & FUNCTION("Character",N) & 'END'

'COUNTRY:' & FUNCTION("-",3) & 'END'

'COUNTRY:---END'

Thanks a lot

jvitantonio — Wed, 18 Jul 2012 07:40:51 GMT

Yes. Use the Repeat function:

Repeat('-',3)

Miguel_Angel_Baeyens — Wed, 18 Jul 2012 07:45:01 GMT

Hi Pedro,

Elaborating what qlikuser14 says:

'COUNTRY:' & Repeat('-',3) & 'END'

Hope that helps.

Miguel

Wed, 18 Jul 2012 07:46:23 GMT

Thank you both.