Shell Programming and Scripting

Learning, stumbling! My progress in shell scripting is slow. Now I have this doubt:

I have the following file (users.txt):

Code:

AU0909,on
AU0309,off
AU0209,on
AU0109,off

And this file (userson.txt)

Code:

AU0909
AU0209
AU0109
AU0309

I just want to set those users on userson.txt to "off" in the users.txt file. String substitution.
This is an exercise with AWK, I already know other methods to change it but I'm interested in AWK.

Now, I tried this in a script:

Script1.sh

Code:

 
AuxLine="AU0909"
awk -v idusr=${AuxLine} 'BEGIN { FS = "," } ; $0 ~ idusr { print $2}' users.txt

That works for that given string, but I for hours I can't see why this does not work:

Code:

while read AuxLine
do
  awk -v idusr=${AuxLine} 'BEGIN { FS = "," } ; $0 ~ idusr { print $2}' users.txt
done < userson.txt

The variable is passed correctly (read from usersons.txt) as I already tried printing it with no search pattern and it did print. I just can't see how the loop is preventing this simple command to work.

Any clues?

First something really basic. In the second part you are using a file with a different name? Does it exist?

Which file is different?

I was typing myself the names of the files on the post so if there is any mistake with it I am sure the files do exist (they're being read properly)

I mean users.txt and UserUpdateList . The two examples operate on different files.

Oh yes, users.txt = UserUpdateList.

I changed the name in the post just to make it less confusing. I'll edit now.


But to add somethig: I just discovered this:

Code:

while read AuxLine
do
   echo $AuxLine "is it this?: AU0922"
   awk -v idusr=${Auxa} 'BEGIN { FS = "," } ; $0 ~ idusr { print $4}' users.txt
done < userson.txt

That echo DOES NOT show the value of $AuxLine on the result of the script. the output is:

Code:

 is it this?: AU0922
 is it this?: AU0922
 is it this?: AU0922
 is it this?: AU0922
         ...

However, if I echo the value alone (echo $AuxLine) it does show.

Maybe this is related to my issue?

This is strange. What OS are you using and what shell?
Is userson.txt exactly like in you sample?
If you are on Solaris, use /usr/xpg4/bin/sh and /usr/xpg4/bin/awk instead of /bin/sh and awk

I am using ubuntu 10.10: #!/bin/bash

Scrutinizer , you are leading me closer to the answer
The file userson.txt "looked" exactly like in the code I wrote, but it was generated like this:

Code:

grep "0 AU.*" usersin.txt | cut -d' ' -f2 >> userson.txt

The file usersin.txt :

Code:

 Issued: message 1
1 AU0922
1 AU0905
1 AU0912
1 AU0923
0 AU0922
0 AU0900
0 AU0901
0 AU0902

I just tried the previous codes with a manually generated userson.txt and IT DID work..

Any idea what is happening after that grep? My guess is some encoding issue..