Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Can someone tell me more about string in qlikview?
How to manipulate string?
Which are the different fucntions (CONCAT, SUBSTR, ....) to manipulate string and how to use them?
Thank in advance for your help
Hi,
As Stefan suggest above, if you want to concatenate strings, do as follows:
'Text1' & '/' & 'Text2'
Hope that helps.
Miguel
Just hit F1 to open the Help file from your desktop client and search for
string functions
and
string operators
Regards,
Stefan
Hello Swuehl
Thanks a lot for that but i didn't see any function related to CONCATENATION of several strings.
Could you help me if you know, please?
Standing by ....
Hi,
As Stefan suggest above, if you want to concatenate strings, do as follows:
'Text1' & '/' & 'Text2'
Hope that helps.
Miguel
Hi,
Concat('abc' & 'x2z') returns abcx2z
subfield(S, ';' ,2) returns 'cde' if S is 'abc;cde;efg'
subfield(S, ';' ,1) returns NULL if S is an empty string
subfield(S, ';' ,1) returns an empty string if S is ';'
right('abcd',2) returns 'cd'
left('abcd',3) returns 'abc'
mid('abcd',2) returns 'bc'
these are the most used.
Regards
MC
In the referenced chapter 'String operators' you should find the concatenation operator &.
If you want to concatenate field value, i.e. perform an aggregation, you need to look into (chart) aggregation functions, namely concat(), as well.