I'm curious if it's possible. I have a job feed. The title of the feed is formatted this way: Job title at Comany (City, State) plus there's also description item.

Is it possible to reformat this feed to break up title into separate items? Basically anything before word AT would go into title, between AT and () would be company, and everything in () would be location.

This would offer greater styling in displaying feed on website and use it for other stuff like display jobs on a map, because we already have location.

I thought Yahoo Pipes might help, but I couldn't figure it out.

I've seen a site do something like that, I'm not sure if they do it automatically or they do it manually. But manual is too time-consuming and I won't be able to keep track of them.

I have a feeling PHP/JS might be able to do it.

Thanks =)