Extracting Postcode Sectors From Postcodes

[beebass]

Hi there

I'm currently using Crystal 9. I need to be able to extract the postcode sector from each postcode that is held in a database. All of the postcodes held have a space between the two seperate parts, i.e. XXXX YYY, or XXX YYY. The postcode sector would be the XXX Y or XXXX Y part of the postcode. Any ideas how I could extract this from the postcode field?

Thanks

Beebass

 

[bdreed35]

This should work with the scenario's that you provided:

local stringvar input := {table.postal_code};
local numbervar space_pos := instr(input," ");

if space_pos > 0
then left(input,space_pos + 1)
else input

~Brian

 

[MrBillSC]

You need to search for the blank with the Instr function:

If Instr({table.postcode}," ") > 0 then
Left({table.postcode},(Instr({table.postcode}," ") + 1))

MrBill