How to split data in Table box?

[#1]

Hi,

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

WA157EN

E66NN

output should be

WA15

E6

Please can anyone help me.

Thanks.

[Anonymous]

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

[#3]

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]

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

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

[#5]

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

left([Postcode], ' ')

[#6]

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