>From what I can make out by your example, all you have to do is replace ' ' (space) with '\n' (newline) using something like sed. Is this what you want ? Regards, Sharninder On Thu, 2006-04-27 at 05:12 -0500, Russell McGaha wrote: > Folks; > I've got a FileMaker exported csv files in the following format: > > Part#,Disc.,List Price, ... ,Competitor1 part# > ,,, ... , compeditor2 part # > > . > . > . > ,,, ... ,compeditorx part# > Part#,Disc, List price, ... ,Competitor1 part# > > I currently have to manually parse the Competitor2 thru competitorx > part#'s on to the previous line. > Any one have any idea(s) how I might be able to automate this > procedure? > > Russell > _______________________________________________ > X-Unix mailing list > X-Unix at listserver.themacintoshguy.com > http://listserver.themacintoshguy.com/mailman/listinfo/x-unix > > Listmom is trying to clean out his closets! Vintage Mac and random stuff: > http://search.ebay.com/_W0QQsassZmacguy1984