replace

[wshost]

What I want to do is replace every 4th delimiter with another character and create an array with it. For example:

206|555-5555|CA|Bainbridge Island|209|555-555|CA<br>Angels Camp|209|555-555|CA|Angels Camp

As you can see I have 4 fields separated by "|". I was thinking of somehow replacing every 4th delimiter with a different delimiter to distinguish the data but I now have a feeling there is a better way. I need to somehow get this data into an array so I can put it into a MySQL database with fields such as:

areacode, phonenumber, state, city

all in an array. But as you can see my string above has 4 fields separated by a delimiter and then starts over with the same delimiter. ah.. no clue what to do and I have a feeling it's something really easy. Thank you for any ideas.

[wshost]

The <br> in the string I posted is supposed to be a |

It's too late. 🙂

[Anon]

$array=explode('|',$biglongstring);
for($i=0; $i<count($array); $i+=4)
{
$record = array(
'areacode' => $array[$i],
'phonenumber' => $array[$i+1],
'state' => $array[$i+2],
'city' => $array[$i+3]
);
$records[]=$record;
}

print_r($records);

[wshost]

Thanks a million. I'll give that a try, it looks to be exactly what I need.

🙂