If that's the exact string you have (which I doubt) then your code
should look something like
<?
$string=" | 36310 ABBEVILLE |
| 35440 ABERNANT |
| 35005 ADAMSVILLE |
| 35540 ADDISON |
| 35006 ADGER |
| 35441 AKRON |";
$nl="\n";
$array=explode(" |$nl | ",$string);
while (list(,$zip)=each($array)) {
$zip=explode(" ",$zip);
$zipcode=intval($zip[0]); // The zip code
$zipcity=$zip[1]; // The corresponding city
}
?>
Notes on the code above:
1. Your string most probably doesn't look like that, in which case
you'll have to adapt the code to it;
2. You'll have to do some custom changes to the first and last entry
because they will contain some extra stuff (the first zip will start
with " | " - and therefore evaluate to 0, and the last city will end
with " |" which is not right;
3. Depending on the source OS, you may have to change $nl to "\r\n"
instead of simply "\n".
Anyway, that should be the general idea.
Bogdan
Keith Posehn wrote:
> I have a huge block of zip codes I need to seperate into their constituent
> parts for a query of a database. The block looks like this (in part):
>
> | 36310 ABBEVILLE |
> | 35440 ABERNANT |
> | 35005 ADAMSVILLE |
> | 35540 ADDISON |
> | 35006 ADGER |
> | 35441 AKRON |
>
> I need to use eplode (probably) to seperate this all out into two arrays,
> one of codes, the other of names--presumably named $zips[] and $cities[]
> with the rest of the data dumped.
>
> I have gone and looked at the various functions docs at php.net, but they
> haven't really helped to answer my question as much as I would like. Any
> information is appreciated.
>
> Thanks
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
