How to Manipulate Text File

[george_114]

How to manipulate textfile x to become xt using script.Content of xt :

970 /etc/hosts
976 /etc/passwd
980 SO122310000123

Thanks in advanced for your help.

[RAC_1]

Confusing. What exactly you want?

File xt to look like as follows?
970 /etc/hosts
976 /etc/passwd
980 SO122310000123

Post.

[george_114]

Yes RAC the xt file look like :
970 /etc/hosts
976 /etc/passwd
980 SO122310000123

[RAC_1 · Accepted solution]

cat xt|grep -i "pinguin"|awk '{print $4, $5}'

Hope this helps.

[Elmar P. Kolkman]

One AWK can do the trick too, and not only for pinguin print jobs, by ignoring all lines until the header line, like this:

awk '
started==1 { print $4,$5 }
$1 == "Rank" { started=1 }
' xt

[george_114]

RAC, do you have other alternative solution without using awk ???Because my UNIX SILENT command can not proses awk statement.Thanks in advance.

[RAC_1]

cat xt|grep -i "pinguin"|cut -d " " -f4 -f5

[Elmar P. Kolkman]

grep -i pinguin x | cut -c36-50 > xt
(I can be mistaken in the numbers, but something like this should work)

[john korterman]

Hi,
try this simple approach, using xt as $1:

#!/usr/bin/sh
while read a b c d e f g
do
echo $b | grep -q pinguin@localhost
if [ $? = 0 ]
then
echo $d $e
fi
done <$1

regards,
John K.

[David Totsch]

If the first six lines of the output is always the same and the data you are looking for is always in the same colums...

sed -n "7,$ p" x | cut -c41-66

Enjoy,
-dlt-