Convert awk statements to variables

Posted on 2008-10-07
Last Modified: 2013-12-21
I am trying to read in a simple colon delimited datafile (i.e. mysql.accts), parse through it with awk to extract out the variables for the MySQL account username, password and database name.

My awk skills are a bit rusty, but when I kick off the script, I am encountering this error message:

./ line 35: username1:mypassword1:database_name1: No such file or directory
./ line 36: username1:mypassword1:database_name1: No such file or directory
./ line 37: username1:mypassword1:database_name1: No such file or directory

I have attached portions of the code via snippets for reference needs.

mysql.sites datafile...



Script to read in datafile and extract variables...






# Gather info about each site (one at a time) & extract variables


for site in $(awk '{print $1}' < "$site_list" )


DBUSER=$(awk -F: '{print $1}' < "$site" )

DBPASS=$(awk -F: '{print $2}' < "$site" )

DBNAME=$(awk -F: '{print $3}' < "$site" )

echo "$DBUSER -- $DBPASS -- $DBNAME"

   let "n += 1"


Open in new window

Question by:Michael W
  • 2

Expert Comment

ID: 22659937
It looks like you're only passing in the first collumn instead of the entire line?  Try building your site variable with collumn $0 (all collumns)
for site in $(awk '{print $0}' < "$site_list" )

Open in new window


Accepted Solution

cflong earned 500 total points
ID: 22659995
In addition, the reason for the errors is that when you direct stdin with <, shell epects a filename.  Since you have the text in a variable, you can echo that and pipe it to awk
DBUSER=$(echo ${site} | awk -F: '{print $1}' )

DBPASS=$(echo ${site} | awk -F: '{print $2}' )

DBNAME=$(echo ${site} | awk -F: '{print $3}' )

Open in new window

LVL 14

Expert Comment

ID: 22660011
Does that meet your requirements?


while read LINE; do

  DBUSER=$(echo $LINE | awk -F: '{ print $1 }')

  DBPASS=$(echo $LINE | awk -F: '{ print $2 }')

  DBNAME=$(echo $LINE | awk -F: '{ print $3 }')

  echo $DBUSER -- $DBPASS -- $DBNAME

done < $site_list

Open in new window

LVL 29

Author Closing Comment

by:Michael W
ID: 31503859
You are a god! Thanks!

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension ( This reminded me of questions tha…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now