topic Delimiter problem? in QlikView

Delimiter problem?

Fri, 09 Mar 2012 04:59:10 GMT

Hi Friends

I have field name like QVG-AMP-AHF

so i want extract AMP from Above Field Name.

i have used the Function Subfiled(QVG-AMP-AHF,'-',1)

but i am getting only QVG.

Please help me

Thanks in Advance

Suresh

Delimiter problem?

CELAMBARASAN — Fri, 09 Mar 2012 05:09:18 GMT

Hi,

param 1 is to fetch the first one,here you need to use it as 2

Subfiled(QVG-AMP-AHF,'-',2)

Celambarasan

Delimiter problem?

Fri, 09 Mar 2012 05:12:50 GMT

Thanks celambarasan

if i have feild name QVG-AMP means .i have to use Subfield(QVG-AMP,'-',1),

then i will get AMP

Re: Delimiter problem?

CELAMBARASAN — Fri, 09 Mar 2012 05:17:41 GMT

Hi,

No.Still you will get QVP only.

Subfield() splits the given string to separate values by using the given delimiter and according to the value(third param) you given it will fetch corresponding value.

Example:

QVP-AMP-AHF splitted QVP,AMP,AHF.

if you specified as 1 then returns QVP,for 2 AMP,for 3 AHF.

By default it will be 1 if you didn't specified.

Celambarasan

Delimiter problem?

Fri, 09 Mar 2012 05:23:26 GMT

you are right.

for getting AMP,.i have to use Subfield(QVG-AMp,'-',-1)

instead of 1, i have to use -1

.now i got the Answer

Thanks for your reply

Delimiter problem?

CELAMBARASAN — Fri, 09 Mar 2012 05:28:09 GMT

Hi,

Yes if you -1 also you will get answer.

Mostly its easy to use 2 which is easier for our understanding like 1 is to get first value,2 is to get second value...

In that case you have to imagine as 0 is to get first value,-1 is to get second value,-2 is to third value...

Subfield(QVG-AMp,'-',2)

Celambarasan

Delimiter problem?

Fri, 09 Mar 2012 15:50:39 GMT

and simply using:

Subfield(QVG-AMP-AHF,'-')