nixCraft

Hello,
In a delimited flat file how to select the rows that have missed columns. Is there any unix commands
Thanks - Joe

row can be selected using various commands and while loop. you can use awk
you need to give me more information and examples so that i can help out ya

__________________
Raj
Linux rulz.
I have never turned back in my life ; I shall not do so today.. haha

Hi Raj,

Example,

Col1 Col2 Col3 Col4
-----------------------
100|200|300|400
100|200|300
100|200|300|400
100|200

In the above example, I have 4 records in a flat file. The file has 4 columns.
In the rows if all the column values are present, that record will be selected without any problem.

I want to pick the rows 2 and 4 in the above example. How do I get that.

Thank You
Regards - Joe

Try awk as follows

__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool

Hello,
How do I implement this for a tab delimited file.
In Unix command how to provide tab as delimiter instead of '|'
Thanks - Joe

Hello,
I got the answer for ta delimited ('\t')

Now, I want to get the result with the row numbers.

Example:

100 200 300 400
200 300 400
300 400 500 600

Result;

1 100 200 300 400
3 300 400 500 600

Thanks - Joe

Try