topic Re: change lines in text file in Operating System - Linux

change lines in text file

uadm26 — Fri, 05 Jan 2007 08:55:18 GMT

Hi, guys
I need a script to work a file whith this ouptut:

EI_FNC-ARCH-DIA
01/05/07 14:00:00

EI_TERC-ARCH-DIA
01/05/07 16:00:00

EI_PDL-ARCH-DIA
01/05/07 15:30:00

and change that output to this:
EI_FNC-ARCH-DIA|01/05/07|14:00:00
EI_TERC-ARCH-DIA|01/05/07|16:00:00
EI_PDL-ARCH-DIA|01/05/07|15:30:00

Thanks for all,
JT

Re: change lines in text file

Ivan Krastev — Fri, 05 Jan 2007 09:05:57 GMT

Try this one:

awk '/EI/{getline t;print $0 t;next}' filename

regards,
ivan

Re: change lines in text file

Peter Godron — Fri, 05 Jan 2007 09:07:20 GMT

Hi,
how about:
grep -v '^$' a.txt| sed '$!N;s/\n/ /' |sed "s/ /|/g" > b.txt

Remove a balnk lines
Substitute return characters
Substitute filed spaces with '|'

Input data in a.txt, output data in b.txt

Re: change lines in text file

Hemmetter — Fri, 05 Jan 2007 09:15:43 GMT

Hi JT

a quick and dirty shellscript:

cat datafile |
while read L1; do
if [ -z "$L1" ]; then
: # do nothing
else
read L2
echo "$L1 $L2"
fi
done | sed "s/ /|/g"

rgds
HGH

Re: change lines in text file

Ivan Krastev — Fri, 05 Jan 2007 09:18:35 GMT

Ooops forgot | :

awk '/EI/{getline t;print $0 "|" t;next}' filename

regards,
ivan

Re: change lines in text file

uadm26 — Fri, 05 Jan 2007 09:29:12 GMT

Ok that's it, thanks for all.