Searching in lists with regex?

Hi, I have some lists of persons and want to search e.g. in an area of the zip-code like show me the zips from 79*** or show me 79000...80000. Is this possible? And when, how?

Thanks al lot for all help.
greetings
Mapache

The Test-site here: ae.die-marketingmacher.de/ then go to "Mitglieder" > "Mitglieder-Suche"

If it's an integer field then it'll already allow you to search between 2 values. Text fields can't do between values searching. There's no regex searching however, sorry.

Hi krileon,

thanks for your tip. You are right, the zip-field was only text now i changed to integer.

But now I have a new problem because in Germany we have zip-Codes like "09132" with a Zero at the beginning. So i switch the integer to "unsigned zerofill". O.k. this part works. But now there a people from Switzerland with only 4digit-zipcodes. They have now already a "0" in front.

Any Idea how the go one??

greetings
Mapache

You can't have leading zeros for an integer field unfortunately. If you assume everyone is going to have a leading zero you could use a delimiter field to display the field instead of letting it display normally (e.g. 0[cb_zip]).

Thanks krileon,

I know this part, for that I use "unsigned zerofill" and the field is limited to 5 digits. It is working for Germany, other country now I will make a little workaround. not perfect but we only have 30 Personsoutside.


The task at least is to make it possible to search zip-code in a range. Perhaps you know a quite other solution?

If not, we can close this thread.

Thanks and a good day
Mapache

Not aware of any other solution except creating a new fieldtype plugin specific to zipcode usage as PHP functions used to sanitize integer fields will remove leading zeros all the time.