Concatenate Loop Results

RichZR · #1 03-10-2010

Hi,

I have the following situation:

Code:

Param1Values = AAAA,BBBB
 
Param1=$(echo $Param1Values| tr "," "\n")
for x in $Param1
do
    db2 select X from Y where Z IN ('$x')
done

Franklin52 · #2 03-10-2010

Something like:

Code:

Param1Values="AAAA,BBBB"

x=$(echo $Param1Values | sed "s/\(.*\),\(.*\)/'\1','\2'/")
db2 select X from Y where Z IN ('$x')

RichZR · #3 03-10-2010

Quote:

Originally Posted by Franklin52

Something like:

Code:

Param1Values="AAAA,BBBB"
 
x=$(echo $Param1Values | sed "s/\(.*\),\(.*\)/'\1','\2'/")
db2 select X from Y where Z IN ('$x')

Regards

Thanks for the reply.

Will the above cater for an infinate amount of values that could be stored in the parameter?

Cheers

malcomex999 · #4 03-10-2010

if you have more than two values...

Code:

Param1Values="AAAA,BBBB,CCC,DDD"
x=$(echo $Param1Values | awk -F, -v s=\' '{for(i=1;i<=NF;i++) {printf s $i s;printf (i==NF?_:",")}}' ) 
db2 select X from Y where Z IN ('$x')

RichZR · #5 03-10-2010

Quote:

Originally Posted by malcomex999

if you have more than two values...

Code:

Param1Values="AAAA,BBBB,CCC,DDD"
x=$(echo $Param1Values | awk -F, -v s=\' '{for(i=1;i<=NF;i++) printf s $i s","}' | sed 's/,$//') 
db2 select X from Y where Z IN ('$x')

Nealry there

The above gives the result:

db2 select X from Y where Z IN (''AAAA''BBBB''CCC''DDD'')

How would i get the code to give the results in the format:

db2 select X from Y where Z IN ('AAAA','BBBB''CCC','DDD')

So that there is single quotes around each string, and comma seperated?

Thanks once again!

radoulov · #6 03-10-2010

Code:

perl -e'
  printf "select X from Y where Z IN (%s)\n",
    join "," , map "\47$_\47", split ",", $ENV{Param1Values}
    '

RichZR · #7 03-10-2010

Quote:

Originally Posted by radoulov

Code:

perl -e'
  printf "select X from Y where Z IN (%s)\n",
    join "," , map "\47$_\47", split ",", $ENV{Param1Values}
    '

You should export the Param1Values variable before executing the script:

Code:

export Param1Values

Thanks for the reply, much appreciated, but i am trying to stay away from perl and use AWK or SED if possible.

Cheers

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Not able to store the results of perl recursive function when applied under for loop	anthriksh2000	Shell Programming and Scripting	0	02-12-2010 06:58 AM
doing a for loop adding up the results	hcclnoodles	Shell Programming and Scripting	2	12-08-2009 09:14 AM
2 CMD results on the same line while rexing in a loop	linux_lou	Shell Programming and Scripting	8	10-09-2009 04:46 PM
Perl - Iterating a hash through a foreach loop - unexpected results	quantumechanix	Shell Programming and Scripting	5	12-15-2003 06:08 PM