topic Re: Split or subtract value in QlikView

Split or subtract value

srinivasa1 — Tue, 11 Feb 2014 11:35:42 GMT

pl guide me, how i can subtract or split value into two filed from below list

01-Mohan-ABC-IT

02-Raj-test-A/c

03-Abh-Rohab-A/c

i would like to substrata into two filed as below

Filed

Filed 2

Mohan-ABC-IT

Raj-test-A/c

Abh-Rohab-A/c

luis_pimentel — Tue, 11 Feb 2014 11:41:33 GMT

You could play withLEFT(), RIGHT() and LEN() funcions, like:

LEFT(yourfield,2) AS Field1,

RIGHT(youfield,LEN(yourfield)-2) AS Field2

luis_pimentel — Tue, 11 Feb 2014 11:42:10 GMT

Take a look also to the SUBFIELD() function.

Tue, 11 Feb 2014 11:45:29 GMT

or you use subfield(yourfield,'-',1) as Field1

and right(yourfield,len(yourfield)-3) as Field2

ashwanin — Tue, 11 Feb 2014 11:52:24 GMT

Hi Srinivas,

Please go through the qv.

Here two functions used to get your desried output.