This week's book giveaway is in the Agile and Other Processes forum. We're giving away four copies of Darcy DeClute's Scrum Master Certification Guide: The Definitive Resource for Passing the CSM and PSM Exams and have Darcy DeClute on-line! See this thread for details.
Seriously, I'm a bit confused because you're showing the data as space separated but your indicating a problem with commas. Which way is it? I would say that the data is not in the correct format if you mean to have commas as the delimiter. The traditional manner is that each field is surrounded by the double quote character so that you really separate by them, not the commas. Of course, having an embedded double quote character then needs to be addressed if your data supports it.
<a href="http://forums.hotjoe.com/forums/list.page" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.
Originally posted by Peter Primrose: I meant the space to represent the commas.
this is the exact format.
What I'm saying is that unless you show us exactly what the file looks like, we might be missing an opportunity. If the fields are always the same size, then we could use that. If there are always exactly 7 numbers at the end, we could use that. If that "Washington/Dallas/North, East" field never contains any digits, we could use that. But we can't help you parse a file whose format is unknown to us.