Bash : adding text from textfile to variable using awk

Question

I am trying to use the values from my textfile in my bash script

AantalUsers=$(cat newusers.txt | wc -l) 
echo $AantalUsers
lijstUsername="" 
lijstWachtwoord=""

for ((i = 0 ; i < $AantalUsers ; i++ )); 
do
  lijstUsername=`awk -F" " '{print $1}' test.txt` 
  lijstWachtwoord=`awk -F" " '{print $2}' test.txt` 
done <test.txt 

echo $lijstUsername 
echo $lijstWachtwoord

My textfile looks like this :

This is the output that I get :

The first list works great but for the second one I only get the last value of the textfile.

What could be the problem?

As a general piece of advice, it's a lot more useful to us if you post your input/output as plain text inside a code block instead of using screenshots. — Tom Fenech
– Tom Fenech, Commented Oct 12, 2015 at 10:06

anubhava · Accepted Answer · 2015-10-12 09:43:30Z

1

You can use this awk command:

awk '{
   for (i=1; i<=NF; i++)
     a[i,NR] = $i;
   n = (n < NF ? NF : n)
}
END {
  for (i=1; i<=n; i++)
     for (j=1; j<=NR; j++)
        printf "%s%s", a[i,j], (j==NR?ORS:OFS)
}' file

Output:

user1 user2 user3
user1pass user2pass user3pass

answered Oct 12, 2015 at 9:43

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mathias Verhoeven Over a year ago

I still have the same output as before.

anubhava Over a year ago

This is copy/paste of output I get from awk. You might have \r in your lines. Run dos2unix to fix it first.

Mathias Verhoeven Over a year ago

Okay I will do that next time. Thanks for the advice

Collectives™ on Stack Overflow

Bash : adding text from textfile to variable using awk

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related