Piping in UNIX

simo007 · #1 (**permalink**) 05-13-2007

All,
I am a UNIX novice with a question that I hope you can help me with.
I have a UNIX application called "Tole" that formats and displays specific information about customers. I can display the information for up to 30 customers by seperating customer IDs using commas in this format:
Tole -c 10,20,30... I would like to have the application pull the values shown after the -c argument from a .csv file (say customers.csv) and run them in groups of 30. Also, I would like the output piped and appended to a results file (say results.csv) as in: Tole -c 10,20,30 >> results.csv.
Thank you in advance for your help.
Adam

jim mcnamara · #2 (**permalink**) 05-14-2007

Code:

#!/bin/ksh
awk -F, '{ for(i=1; i< NF; i++) 
               if(i%30 == 0 ) {printf("%s\n", $i) }
               else  {printf("%s,",$i) } 
             END {print "" }
           ' | \
while read parms
do
      Tole -c "$parms" 
done >> result.csv

simo007 · #3 (**permalink**) 05-17-2007

Thank you Jim. Can you take me through this command and let me know what directory this needs to go under?
Regards,
Adam

simo007 · #4 (**permalink**) 05-23-2007

Quote:

Originally Posted by jim mcnamara

Code:

#!/bin/ksh
awk -F, '{ for(i=1; i< NF; i++) 
               if(i%30 == 0 ) {printf("%s\n", $i) }
               else  {printf("%s,",$i) } 
             END {print "" }
           ' | \
while read parms
do
      Tole -c "$parms" 
done >> result.csv

Can someone tell me if I need to be logged in as root and explain what the commands mean?
Thank you,
Adam

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
piping from C to python in UNIX	Dreams in Blue	High Level Programming	0	05-04-2008 08:02 AM
Java with Unix (Redirection + Piping)	fluke_perf	High Level Programming	3	04-30-2008 11:52 AM
piping	lnatz	Shell Programming and Scripting	1	07-14-2006 02:30 AM
Help (Piping ls, tr, cut)	scan	Shell Programming and Scripting	2	02-11-2006 08:40 AM
redirecting/piping	crashnburn	UNIX for Advanced & Expert Users	3	03-25-2002 03:07 PM

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


	Powered by