topic Trim Field values in QlikView

Trim Field values

Tue, 20 Nov 2012 02:12:27 GMT

UGSCU-G

QUSJIE-G

when field values are like this if i want to omit the '-G' just to get

UGSCU

QUSJIE

????

Re: Trim Field values

Anonymous — Tue, 20 Nov 2012 02:26:49 GMT

If you always want to remove every instance of '-G', then you can just use:

Replace(FIELDNAME, '-G', '') as FIELDNAME

Re: Trim Field values

Tue, 20 Nov 2012 02:44:43 GMT

sorry not to mention that there are also other values as

KSIJED-M

OQKDL-C

by using above condition replace i can eliminate -G but how about '-M' & '-C' from the field values??

Re: Trim Field values

Anonymous — Tue, 20 Nov 2012 02:48:35 GMT

Well, if the '-G/M/C' is always at the end of the string, it might be easier to just pick everything on the left of the first '-'. Something along these lines:

Left(FIELDNAME, index(FIELDNAME,'-',1)) as FIELDNAME

Re: Trim Field values

Tue, 20 Nov 2012 03:04:00 GMT

THE ABOVE EXPRESSION RETURNs the values with ending '-' as

KSIJED-

OQKDL-

UGSCU-

QUSJIE-

i tried to change the position number still the same outcome??

Re: Trim Field values

Anonymous — Tue, 20 Nov 2012 03:11:24 GMT

Left(FIELDNAME, index(FIELDNAME,'-',1)-1) as FIELDNAME

Re: Trim Field values

Tue, 20 Nov 2012 03:18:08 GMT

THANKS JOHN.

Re: Trim Field values

Tue, 20 Nov 2012 07:01:37 GMT

this is good

but if we have different symbols in the values

then how we use this expr

like _,-,&,#,@

this type of special characters how to remove this

all in one field values

Re: Trim Field values

Anonymous — Tue, 20 Nov 2012 07:03:15 GMT

If you're only looking to remove certain characters, use the function PurgeChar()

Re: Trim Field values

Tue, 20 Nov 2012 07:09:43 GMT

thanks

purgechar()

it give all values without symbols

but i need to trim from that special character onwords

like above exm

Left(FIELDNAME, index(FIELDNAME,'-',1)-1) as FIELDNAME

here how to use multiple symbols

Re: Trim Field values

Anonymous — Tue, 20 Nov 2012 09:29:18 GMT

hi khushi,

1 option is to change all tat symbols into one unique symbol n den use index function or subfiled function.....

regards,

Vaibhav