topic Re: select fields from a report in Operating System - HP-UX

select fields from a report

Dave Walley — Tue, 07 May 2002 13:50:35 GMT

Hi.

A program generates a line of test delimited by |, I have now been asked to extract from this report a number of different fields namely the 4,6 and 10 (these may change from time to time). The fields are not of fixed length and the line can be over a 1000 characters long. I attach a portion of the line. Remember although the line may appear on many lines it is all contained in one line.

I look forward to your responses.

Thanking you

Dave

Re: select fields from a report

Patrick Wallek — Tue, 07 May 2002 13:55:18 GMT

The easiest way I can think of would be to utilize awk, or if awk can't handle a line of that length, then gnu awk (gawk - http://hpux.connect.org.uk/hppd/hpux/Gnu/gawk-3.1.0/ )

I would do something like:

# awk -F| '{ print $4,$6,$10 } filename

Re: select fields from a report

A. Clay Stephenson — Tue, 07 May 2002 13:55:52 GMT

This is trivially simple as long as any one input line does not exceed 3,000 characters - if so you need the Gnu version of awk.

cat myfile | awk -F '|' '{print $4,$6,$10}'

Re: select fields from a report

harry d brown jr — Tue, 07 May 2002 13:56:27 GMT

cat filename|cut -d"|" -f4,6,10

or

cat filename|awk -F\| '{print $4," ",$6," ",$10;}'

live free or die
harry

Re: select fields from a report

Rodney Hills — Tue, 07 May 2002 13:56:49 GMT

awk can do this simply-

awk -F\| '{print $4,$6,$10}' otfile

-- Rod Hills

Re: select fields from a report

Sachin Patel — Tue, 07 May 2002 13:57:15 GMT

use awk for it

cat filename | awk -F| '{print $4 $6 $10}'

Sachin

Re: select fields from a report

John Palmer — Tue, 07 May 2002 14:02:17 GMT

Hi Dave,

I agree with Patrick on awk but you'll have to quote the pipe sign. Something like

awk -F '|' '{print $4 " " $6 " " $10}'

Regards,
John

Re: select fields from a report

Magdi KAMAL — Wed, 08 May 2002 06:56:28 GMT

Hi Dave,

# awk -F '|' '{print $4, $6, $10}' fileToBeAnalzed

Will produce what you are looking for since each line within your file is not exceeding 3000 characters.

Magdi

Re: select fields from a report

Raju Joseph (PDI) — Wed, 08 May 2002 12:27:02 GMT

Hi

awk -F '|' '{print $4 " " $6 " " $10}'

is the simplest way to extract the columns.

Did this solve your problem ? OR you still want to load this extracted data to aother database/table ?

Raju