How to manipulate STRING in Qlikview?

[#1]

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

[swuehl]

Just hit F1 to open the Help file from your desktop client and search for

string functions

and

string operators

Regards,

Stefan

[#3]

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 ....

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

As Stefan suggest above, if you want to concatenate strings, do as follows:

'Text1' & '/' & 'Text2'

Hope that helps.

Miguel

[#5]

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

[swuehl]

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.