Extracting particular column value

talat · 09-08-2007, 02:43 PM

HI Guys

I need little help.Consider that i have a file which contain multiple lines
.In each line there is one particular field which has some value.I just want to extract that value and place that in a new file.The example of the line is given below

service: month day time info: somethink : client in something 1 staright service=something secured ip=8990000 ip=989898 resp=hsdakhhsd87e734hkdh387374

This whole is in one line and the value i want to fetch is of resp.

Please guide me

Regard
Talat

gnashley · 09-08-2007, 03:43 PM

Something like this should work:

Code:

while read line ;
for word in $line ; do
if [[ "$(echo $word |cut -f1 -d=)" = "resp" ]] ; then
 value_wanted="$(echo $word |cut -f2- -d=)
fi

do < filename.txt

Tinkster · 09-08-2007, 03:56 PM

Code:

egrep -o "resp=.*" file > newfile

Cheers,
Tink

ghostdog74 · 09-08-2007, 08:59 PM

put in some effort next time.

Code:

# awk '{print $NF}' file
resp=hsdakhhsd87e734hkdh387374

Tinkster · 09-08-2007, 11:20 PM

As much to type as my solution, and quite likely slower.

Cheers,
Tink

talat · 09-09-2007, 01:12 AM

Many Thanks guys

talat · 09-10-2007, 11:16 AM

Hi Guys

After extracting the resp value and placing the value in another file, i am now trying to decode the value by mmencode tool.But when i run the cmd

mmencode -u file -o output file

What i get in the output file is the decoded value of only first line or you can say only one decode value .Tell me is this mmencode run only for the first line ?. If yes do i have any alternative ?.

Regard
Talat

Tinkster · 09-10-2007, 01:25 PM

I've never come across mmencode ... what does it do? If it
can't handle your file, throw the content at it via xargs?

cat file2 | xargs -i mmencode ...{}

Where {} is a placeholder for each individual line from the
file that you created in the first step.

Cheers,
Tink

ghostdog74 · 09-10-2007, 06:53 PM

Quote:

Originally Posted by Tinkster

I've never come across mmencode ... what does it do? If it
can't handle your file, throw the content at it via xargs?

cat file2 | xargs -i mmencode ...{}

Where {} is a placeholder for each individual line from the
file that you created in the first step.

Cheers,
Tink

Correct me if i am wrong, xargs have an option -a (--arg-file=file) so i think there's no need for cat.

Tinkster · 09-10-2007, 07:18 PM

That'll depend on the version of xargs... the ones in Solaris for
instance don't.

Cheers,
Tink

ghostdog74 · 09-10-2007, 08:49 PM

Quote:

Originally Posted by Tinkster

That'll depend on the version of xargs... the ones in Solaris for
instance don't.
Cheers,
Tink

yup, that's true. btw, the -o option of egrep is not available in the Solaris version..or does it?

Tinkster · 09-10-2007, 10:08 PM

Quote:

Originally Posted by ghostdog74

yup, that's true. btw, the -o option of egrep is not available in the Solaris version..or does it?

Which one? :}

The /usr/bin/egrep doesn't.
The /usr/sfw/bin/gegrep does in Sol10, doesn't in Sol9...

Cheers,
Tink

talat · 09-11-2007, 03:33 AM

Hi Guys

I have been able to decode all line via

while read line; do echo $line | /usr/bin/mimencode -u >> outputfile; echo "\n" >> outputfile ; done < inputfile

Thanks & Regard
Talat