Changing a CSV file in Korn shell

riteshm · #1 (**permalink**) 02-27-2006

Hi All,

Please can someone help me how I can read a CSV file with 10 columns and remove the 2nd, 4th, 6th, 8th column and build the new output file. Script to be done in Korn shell.

File contains data like bnt, lb2, lb3, vnw, lb4, lb5, bst, lb6, lb7, vgw (multiple rows)

Output file should contain bnt, lb3, lb4, bst, lb7, vgw (multiple rows)

Thanks in advance.

-RiM

rajeeb_d · #2 (**permalink**) 02-27-2006

awk -F "," '{for(i=1;i<=NF;i++) if(i!=2 && i!=4 && i!=6 && i!=8) if(i<NF) printf("%s,",$i); else printf("%s%s",$i,"\n");}' <filename>

Ygor · #3 (**permalink**) 02-27-2006

cut -d, -f1,3,5,7,9- file1 > file2

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
korn shell script to keep history of same file	watson2000	UNIX for Dummies Questions & Answers	2	10-09-2006 10:38 PM
Read file - korn shell	alienET	Shell Programming and Scripting	5	04-06-2005 02:22 PM
file activity (open/closed) file descriptor info using KORN shell scripting	Gary Dunn	UNIX for Dummies Questions & Answers	3	06-07-2004 01:54 PM
Read a file and replace a value- Bourne and Korn shell	kenix	Shell Programming and Scripting	3	09-20-2002 09:25 AM
Changing korn shell script text Menu colors?	darthur	UNIX for Dummies Questions & Answers	6	01-20-2002 07:15 PM

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


	Powered by