Skip to Content
0
Former Member
May 11, 2009 at 03:04 PM

Showing the first half of a post/zip code

19 Views

Hello,

I am attempting to display a postcode (zip) field within crystal but only want to show the first half of it.

Is this possible?

Using the Left(,4) formula I managed to do this but if I have a postcode of B1 2HZ, it will display B1 2, whereas I only want to show B1

Thanks,

WA