topic Re: extracting records from a data file in Operating System - HP-UX

extracting records from a data file

Joe Robinson_2 — Mon, 10 Dec 2001 20:33:23 GMT

I'm trying to pull a number of records that contain 'X' as the seventh character of the string. I've tried using wild cards (??????X) in a grep statement, as well as [A-Z]....X, but am looking for a simpler, more direct way that I can use in the future as well.

Along with that, I'm curious if there would be a way to direct records that don't have 'X' in them to another file...if the 2 files record count adds up to the original, I'm in like Flynn.

Thanks,
Joe Robinson

Re: extracting records from a data file

Jeff Machols — Mon, 10 Dec 2001 20:35:11 GMT

You already have the best way to extract them grep ??????X

to get the opposite, all you have to do is grep -v ??????X

Re: extracting records from a data file

Joe Robinson_2 — Mon, 10 Dec 2001 20:42:17 GMT

Not sure why that syntax won't work here...that was the first two things I thought of.

Re: extracting records from a data file

Curtis Larson_1 — Mon, 10 Dec 2001 20:44:18 GMT

could always try

sed '/[.]\{6\}X/p'

and those without a X at the 7th character:

sed '/[.]\{6\}X/d'

Re: extracting records from a data file

Jeff Machols — Mon, 10 Dec 2001 20:45:09 GMT

you may need to anchor the grep by doing this

grep "^??????X" file
grep -v "^??????X" file

Re: extracting records from a data file

Jeff Machols — Mon, 10 Dec 2001 20:52:04 GMT

This will work also

cat file | cut -c 7 | grep X
cat file | cut -c 7 | grep -v X

Re: extracting records from a data file

Curtis Larson_1 — Mon, 10 Dec 2001 20:52:29 GMT

and with grep

grep '.\{6\}X'

Re: extracting records from a data file

Jeff Machols — Mon, 10 Dec 2001 21:02:53 GMT

One thing you will want to add to Curtis' is

grep '^.\{6\}X' file

otherwise you will get it if X is the 8th, 9th, etc

the ^ will anchor it to the begining of the line

Re: extracting records from a data file

Curtis Larson_1 — Mon, 10 Dec 2001 21:17:38 GMT

and with awk

awk '/^......X/ {print $0 >> "linesWithX";next} {print $0 >> "linesWithoutX";}'