Shell Programming and Scripting

Hi,

I tried this command given below

---> awk '!/[^a-zA-Z|#$%]/' junk1.txt
Output of xxd is given -

$ xxd junk1.txt
0000000: 3230 3631 7c6a 6f68 6e7c 7a69 6574 1a7c 2061|john|ziet.|
0000010: 370a 3132 3334 7c61 7362 637c 6263 6667 7.1234|asbc|bcfg
0000020: 7c31 300a |10.


It is not able to capture the record which has junk character in it.When i run the above command on this file it gives 0 records. But it is supposed to give the record with junk character.

---------- Post updated at 07:51 AM ---------- Previous update was at 12:26 AM ----------

Any help on this??

Hi,

I have the file with the data as given below :

Code:

$ cat junk1.txt
2061|john|ziet|7
1234|good|boy|6

There is a invisible control character after ziet. This is seen below as 032 .

Code:

$ od -c junk1.txt
0000000   2   0   6   1   |   j   o   h   n   |   z   i   e   t 032   |
0000020   7  \n   1   2   3   4   |   g   o   o   d   |   b   o   y   |
0000040   6  \n
0000042

I am pick records having such characters in them?

I have tried these commands but its not working.

Code:

 awk '!/[^a-zA-Z]/' junk1.txt
 awk '!/[[:cntrl:]]/' junk1.txt

Can anyone help with this?

Those commands should pick records that do NOT contain special characters. This:

Code:

awk '/[^a-zA-Z|]/' junk1.txt

should show records WITH that characters.

@bartus

i am getting the following output if i run that

Code:

]$ awk '/[^a-zA-Z|]/' junk1.txt
2061| john|ziet|7
1234|good|boy|6

It is giving both the records.

Ah ,there are number too , and spaces... If space is good character for you, then:

Code:

awk '/[^a-zA-Z0-9 |]/' junk1.txt

Hi,
This command is not capturing ^@ character (NUL character). Is there anyway i can capture that and send that record to a bad file?

It is working on my end..

Code:

# printf "aaa\x00\nbbb" > file

# cat file
aaa
bbb

# awk '/[^a-zA-Z0-9 |]/' file
aaa

Maybe try some other awk version, like nawk or gawk