Awk to find space and tab.

pinnacle · #1 06-01-2009

Wants to print line when there exist leading or trailing space or tab in fields 2,3 and 5

The below code prints all lines in file even if they dont have leading and trailing space or tab.

Code:

nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^[ \t]*" || $i ~ "[ \t]*$")}}1' file

reborg · #2 06-01-2009

Change the * to +. You have made the extremely common mistake of using an REGEX with a zero length match.

pinnacle · #3 06-01-2009

Quote:

Originally Posted by reborg

Change the * to +. You have made the extremely common mistake of using an REGEX with a zero length match.

Code:

 nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^[ \t]+" || $i ~ "[ \t]+$")}}1' file

reborg · #4 06-01-2009

Yes, but you also have a '1' there, so you are printing every line. You need to delete that too, any you do nothing in the for loop/if statement.

Just check the field number in the for lop and print out the lines you want.

pinnacle · #5 06-02-2009

Quote:

Originally Posted by reborg

Yes, but you also have a '1' there, so you are printing every line. You need to delete that too, any you do nothing in the for loop/if statement.

Just check the field number in the for lop and print out the lines you want.

I removed 1 and now i want to check for leading and trailing space or tab on each field.
The below code returns nothing.

Code:

nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^[ \t]+" || $i ~ "[ \t]+$")}}' file

pinnacle · #6 06-03-2009

Quote:

Originally Posted by pinnacle

I removed 1 and now i want to check for leading and trailing space or tab on each field.
The below code returns nothing.

Code:

nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^[ \t]+" || $i ~ "[ \t]+$")}}' file

Help appreciated

I got the following code to work
But would like to remove sort -u and handle it with in awk

Code:

nawk -F"|" '{for(i=1;i<=NF;i++) {if ($i ~ "^[ \t]+" || $i ~ "[ \t]+$") print $0}}' file | 
sort -u  > outfile

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
for i in `find *` breakdown since the directory name has space	patiobarbecue	Shell Programming and Scripting	3	12-09-2008 10:44 AM
How to find the free space & usage of the particular directory in Hp-Unix?	bobprabhu	UNIX for Dummies Questions & Answers	2	06-27-2008 01:05 PM
Find lines with space between strings	Galt	Shell Programming and Scripting	5	05-07-2008 02:06 PM
How to find the top 6 users (which consume most space)?	RebelDac	AIX	5	09-17-2007 06:36 PM
How to find the size of Process Address space.	S.Vishwanath	UNIX for Dummies Questions & Answers	1	07-10-2001 08:46 AM