Re: data transformation

On 2007-02-14, Mladen Gogala wrote:
> On Tue, 13 Feb 2007 17:44:27 -0500, Chris F.A. Johnson wrote:
>
>> On 2007-02-13, m.t wrote:
>>> I have log file with data like this:
>>>
>>> 20608694;20416953;20420430;20414156;20409061;20606877;20609113;20607051;20607052;20608204;
>>> 20418197;20408410;20606460;20606462;20607297;20607356;20415876;20426551;20419862;20421635;
>>>
>>> Is there a way (Windows or Unix) to transform it to single column ?
>>>
>>> 20608694;
>> ...
>>> 20419862;
>>> 20421635;
>>
>> sed -e 's/;/;\
>> /g' < FILENAME > NEWFILENAME
>>
>> Or (POSIX shell):
>>
>> file=$( tr -d '\012' < ~/txt )
>> set -f
>> IFS=\;
>> printf "%s;" $file
>
> What a disgusting thing to write! You should be ashamed of yourself for
> writing things like that! There are also minors who read this group, think
> of them! In the state of New York, it is illegal to peddle POSIX shell,
> awk and sed to minors!

   Do you mean that in NY, my book is in the adult section?

> This is how you write it:
>
> $ perl -ne 'chomp; foreach $i (split /;/) { print "$i;\n"; }' log

   <shudder>

-- 
   Chris F.A. Johnson, author   |    <http://cfaj.freeshell.org>
   Shell Scripting Recipes:     |  My code in this post, if any,
   A Problem-Solution Approach  |         is released under the
   2005, Apress                 |    GNU General Public Licence