is there a way to Grep for a specific field in a ; separated file.

[Epidemic]

I don't care if it is specifically a grep.

Basically I need to know records which contain a 5 in the 39th field. i want to then pull the entire record for those records containing 5 in the field.


Awk
Grep... I dont really care what magic I just need to do this.

[Steve R Jones]

For clueless people like me:

Quote:

grep is a command line text search utility originally written for Unix. The name is taken from the first letters in global / regular expression / print, a series of instructions for the ed text editor. [1] The grep command searches files or standard input globally for lines matching a given regular expression, and prints them to the program's standard output.

[jkrohn]

Regex and perl would do, can you run a script?

[Rootstonian]

And if you're really hard up for this, I can put togehter a quicky exe application...as long as you're not in a HUGE hurry!

[Epidemic]

Quote:

Originally Posted by Rootstonian

And if you're really hard up for this, I can put togehter a quicky exe application...as long as you're not in a HUGE hurry!

Actually that is really nice of your and i appreciate it . butttttt they project goes beyond just doing a one off specific exe.

[Rootstonian]

Ok, from DOS box, try this

C:\> sort input.tx /+39 output.txt

LOL...should be fun ROFL

[Epidemic]

gunzip -c /data/prospect/sent/081128??.DATA.gz|nawk -F";" '{if ($39 == 5) print $3,$4,$6,$7,$10,$11,$14,$15,$22,$25,$26,$27,$31,$3 8,$39,$41,$70}'

The above command looks at file 081128??.DATA.gz in field 39 for a value of 5 and then prints select fields between 3 and 70