How do I select specific records in a file

[Tison]

I have a file with many records (fixed format).
I need to select all records that start with 4 in the third column.
example
"fred",123,400,"Some text"
"A",0,456,"Text"
"A",0,100,"Stuff"
"A lot of text",99999,490,"A lot of text"

 

[Ogzilal]

Hi,
If the fiels of your file are separated with comma ','
then try this awk script
awk -F, '$3 ~ /4.*/ {print $0}' /path/to/your/file

-F indicate the field separator assumed to be comma here

 

[Ogzilal]

Hi,

If the fiels of your file are separated with comma ','
then try this awk script

To be more precise, use ^4.* ( varet indicates begin with )

awk -F, '$3 ~ /^4.*/ {print $0}' /path/to/your/file

-F indicate the field separator assumed to be comma here

 

[Tison]

Thats exactly it,,,,thanks a ton.