how to create this on bash

packets · 01-09-2012, 03:50 AM

I'm trying to create a script with the ff array

array 1 - foo@fee.com,fee@fee.com,fyii@fee.com (1 line)

array 2 - paul

what I want is to have the ff output in a text file

Code:

foo@fee.com: paul
fee@fee.com: paul
fyii@fee.com: paul

Could this be done on a bash script?

I'm trying this one

Code:

array2=`echo $alias | sed 's/\,/\n/g'`
echo "$array2: $array1"

But the output is

Code:

fee@fee.com
fee@fee.com
fyii@fee.com: paul

Any suggestions?

Nominal Animal · 01-09-2012, 04:23 AM

Try

Code:

emails=('first@example.com' 'second@example.com' 'third@example.com')
printf '%s: paul\n' "${emails[@]}"

printf is a Bash built-in (meaning that if you use it in a Bash script or Bash command, Bash will handle it internally; it will not execute any external program), but it is also available as a separate command (/usr/bin/printf). Both work the exact same way.

In this case, the printf command is given a format string, which contains only one parameter definition. Note that the extra string you want to add after each parameter must be within the format string, you cannot use another %s for it. The \n adds a newline; printf does not automatically add a newline like echo does. When printf is given more parameters than the one format string can handle, it will repeat the format string for each parameter (group). This is why the output is what you want.

packets · 01-09-2012, 05:05 AM

I tried to applied this on my script but it didn't work. Could you advise what went wrong?

Code:

#!/bin/bash

DB=test
DBUSER=root

while read username alias
do
newalias=`echo $alias | sed 's/,/\n/g'`
printf "${newalias[@]}: $username"
done < <(echo "SELECT value1,value2 from update where status = '0' and action = 'aliason';" | mysql --skip-column-names $DB -u$DBUSER)

The output is still the same

Code:

foo@fee.com
fee@fee.com
fyee@fee.com: ben5

packets · 01-09-2012, 07:50 AM

Ok. I discover the resolution. This could be a little dirty script but it seems it works for me though haven't use it in production

Code:

DB=test
DBUSER=root

while read username alias
do
newalias=`echo $alias | sed 's/,/ /g' > /tmp/alias` # replacing command with white space
newalias2=( `cat /tmp/alias` )
for emails in ${newalias2[@]};do
echo "$emails : $username"
done
done < <(echo "SELECT caluew1,value2 from ms_userupdate where status = '0' and action = 'aliason';" | mysql --skip-column-names $DB
 -u$DBUSER)

grail · 01-09-2012, 08:58 AM

Well now that you have provided all information (as opposed to what you think we needed to know):

Code:

DB=test
DBUSER=root

while read username emails
do
    set -- ${emails//,/ }
    for email
    do
        echo "$email : $username"
    done
done < <(echo "SELECT caluew1,value2 from ms_userupdate where status = '0' and action = 'aliason';" | mysql --skip-column-names $DB
 -u$DBUSER)

ntubski · 01-09-2012, 09:14 AM

Quote:

Originally Posted by packets

I tried to applied this on my script but it didn't work. Could you advise what went wrong?

Code:

newalias=`echo $alias | sed 's/,/\n/g'`
newalias=(`echo $alias | sed 's/,/\n/g'`)
## or maybe
IFS=, read -a newalias <<< "$alias"
printf "${newalias[@]}: $username"
printf "%s: $username" "${newalias[@]}"

Quote:

Originally Posted by Nominal Animal

When printf is given more parameters than the one format string can handle, it will repeat the format string for each parameter (group).

Thanks, I hadn't known about this feature.

@grail

Code:


    for email
    do
        echo "$email : $username"
    done
printf "%s: $username\n" "$@"

grail · 01-09-2012, 11:07 AM

Thanks ntubski

Often forget simple is better

Nominal Animal · 01-09-2012, 07:36 PM

Quote:

Originally Posted by packets

I tried to applied this on my script but it didn't work. Could you advise what went wrong?

The printf,

Quote:

Originally Posted by packets

Code:

printf "${newalias[@]}: $username"

should have been

Code:

printf "%s: $username\n" "${newalias[@]}"

Like I explained, the "${newalias[@]}" will expand to one or more parameters. Because there is only one %s in the printf format string, printf will repeat the output once of each parameter.

(Note that I did not check the rest of the scriptlet for correctness.)