Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with a Zip Code (5 numbers) and would select a range from e.g. 231-312. How is it possible to cut the zip codes in a Listbox to 3 numbers?
Much Greetings
Daniel
Can't you use the mid(ZIP Code, 1, 2) function
Daniel,
here are a simple way to group Zip Codes:
See the attached document and have a look in the script.
Rainer
Dear Daniel,
Go in list box expression and write left(Zipcode,3). it will show only 1st three numbers of zip code in list box but does not change thier original value.
You can use =subfield(ZipCode,'-',1) for the 1st 3 digits
OR
You can use =subfield(ZipCode,'-',2) for the last 3 digits
as listbox expression
Regards,
Sajeevan