[X-Unix] parsing help?

[Russell McGaha]

Sharninder;
	What I do manually is to move the competitor2 thru competitorx  
part#s up to the last FULL record line.  some times there is only one  
competitor part # and sometimes there is up to 4; and the way  
FileMaker exports them is to put them on a separate record line by  
themselves.

Russell
On Apr 27, 2006, at 5:51 AM, Sharninder wrote:

>> 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
> _______________________________________________
> 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