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: Richard B. gilbert <rgilbert88_at_comcast.net>
Date: Tue, 13 Feb 2007 13:23:53 -0500
Message-ID: <45D20239.5060906@comcast.net>


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;
> 20414156;
> 20409061;
> 20606877;
> 20609113;
> 20607051;
> 20607052;
> 20608204;
> 20418197;
> 20408410;
> 20606460;
> 20606462;
> 20607297;
> 20607356;
> 20415876;
> 20426551;
> 20419862;
> 20421635;
>
>
>

I'd look at gawk and the "FS" (field separator) variable.

I'm not going to write it for you unless you pay me! Received on Tue Feb 13 2007 - 12:23:53 CST

Original text of this message

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