Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: data transformation

Re: data transformation

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 14 Feb 2007 17:11:43 +0100
Message-ID: <45d33454$0$90268$14726298@news.sunsite.dk>

"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;
> 20416953;
> 20420430;

[...]

awk '$1=$1' RS=";" ORS=";\n" logfile > newfile # use nawk on Solaris

Regards
Dimitre Received on Wed Feb 14 2007 - 10:11:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US