topic Re: awk in Operating System - Linux

awk

maliaka — Tue, 20 Mar 2007 06:39:23 GMT

awk '$1!~/^[0-9]+$/&&$2!~/^[a-zA-Z0-9]+$/{print;exit 1}' tmp.txt

I've got this to work good but the problem is that it's not returning 1 if I have only characters in both fields. I need it to return a vaule of 1 when the first two fields are characters and when the first field is characters and the second field is numbers?

example:

myredcar mybluecar
mycar 192.168.1.10

it's not returning a value of 1 for the first line but it does work for the second line.

Re: awk

Peter Godron — Tue, 20 Mar 2007 06:45:16 GMT

Hi,
have you tried the code without the 'exit 1' ?
Can you please specify the exact requirements.

Re: awk

James R. Ferguson — Tue, 20 Mar 2007 06:47:07 GMT

Hi:

Perhaps:

# awk '$1!~/^[0-9]+$/||$2~/^[0-9]+$/{print;exit 1}' tmp.txt

Regards!

...JRF...

Re: awk

maliaka — Wed, 21 Mar 2007 07:35:20 GMT

I tried that but it returns 1 with all of the lines.

Here is my requirements:

cat f1.txt
myredcar mybluecar
mycar 192.168.1.10
192.168.1.1 192.168.1.2
192.168.1.3

It should return a failure status for all of the above lines and return a successful status for the following line whenever they exist in the file f1.txt

192.168.1.4 host100

The lines however, should not be less than or exceed 2 fields.

awk '{NF ==2}' f1.txt, I would like to add this one to the same awk statement so that I'll have only one line of awk commands.

Re: awk

James R. Ferguson — Wed, 21 Mar 2007 07:45:39 GMT

Hi (again):

OK, so lets consider only the initial character in each field:

# awk 'NF!=2||$1!~/^[0-9]/||$2~/^[0-9]/{print;exit 1}' file

Regards!

...JRF...

Re: awk

maliaka — Thu, 22 Mar 2007 00:02:40 GMT

James

One thing though, it should also fail with the following:

1111111111 myhost100

Notice that the first field doesn't have dots.

Re: awk

Dennis Handly — Thu, 22 Mar 2007 02:54:32 GMT

>I would like to add this one to the same awk statement so that I'll have only one line of awk commands.

Do you really want something that confusing?

>One thing though, it should also fail with the following:
1111111111 myhost100
>Notice that the first field doesn't have dots.

Perhaps you need to write a program in awk. I suppose you could have a ERE that would have 3 dots in it, otherwise you could put more checks in your awk script.
awk '$1 !~ /^[0-9]+\.[0-9]+\.[0-9]+\.[0-9]+$/ || $2 !~ /^[a-zA-Z0-9]+$/ {print;exit 1}'

Above it looks for 3 ".". (I couldn't use the \{3\} syntax to have groups of "###.".)

Re: awk

maliaka — Tue, 27 Mar 2007 22:43:25 GMT

James and Dennis are both good solutions.
Thanks to both of you.