topic Re: How to manipulate STRING in Qlikview? in QlikView

How to manipulate STRING in Qlikview?

Thu, 18 Oct 2012 12:47:08 GMT

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 — Thu, 18 Oct 2012 12:53:35 GMT

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

string functions

and

string operators

Regards,

Stefan

Thu, 18 Oct 2012 13:02:26 GMT

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 — Thu, 18 Oct 2012 13:07:48 GMT

Hi,

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

'Text1' & '/' & 'Text2'

Hope that helps.

Miguel

Thu, 18 Oct 2012 13:08:00 GMT

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

swuehl — Thu, 18 Oct 2012 13:08:14 GMT

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.