[X-Unix] parsing help?

[Russell McGaha]

All;
	I guess what I REALY need to do, is change the pattern  
"<return>,,, ... ," to "," . Is there a simple way to do this?   
because of the <return> char, I'm not sure how to correctly do this.

Russell

On Apr 27, 2006, at 7:55 AM, Russell McGaha wrote:

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