topic Re: How to split data in Table box? in QlikView

How to split data in Table box?

Fri, 21 Nov 2014 15:06:55 GMT

Hi,

Can anyone suggest me how to split data in table box column which is shown below

WA157EN

E66NN

output should be

WA15

Please can anyone help me.

Thanks.

Anonymous — Fri, 21 Nov 2014 15:09:41 GMT

You should be able to sort using the left(), right() or mid() functions. But why does one need 2 characters & the other 4 ?

Fri, 21 Nov 2014 15:11:22 GMT

Thanks. These are the postcodes in different locations. some postcodes are YU7 L90 and some are U9 B56

will it be possible with these functions?

Anonymous — Fri, 21 Nov 2014 15:17:07 GMT

I am guessing here do you want to chop the last 3 characters off ?

left([PostCode], len([PostCode])-3)

Fri, 21 Nov 2014 15:31:58 GMT

If you always have the space in the middle of the postcode you can use

left([Postcode], ' ')

Fri, 21 Nov 2014 15:36:28 GMT

Hi,

Yeah it is possible

Left(field, len(field)-3)

It won't possible when these two values coming form same field.

but it will possible it these two values coming from different fields using Left(field,4) and Left(field,2)

Hope this helps