Converting field into fixed width csv

videsh77 · #1 (**permalink**) 11-02-2007

Hi

I have a file having record as -
1,aaa,a123,a

I need this converted to as 2nd col to 5 chars wide & 3rd col to 6chars wide such as -
1,aaa ,a123 ,a

How we could achieve this? Thx in advance.

videsh77 · #2 (**permalink**) 11-02-2007

Got solution -

awk -F"," '{printf("%-1s,%-5s,%-6s\n", $1,$2,$3)}' fname

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Help with Fixed width File Parsing	sate911	UNIX Desktop for Dummies Questions & Answers	4	05-19-2008 11:18 AM
Changing particular field in fixed width file	dsravan	Shell Programming and Scripting	4	02-11-2008 06:08 PM
Converting a Delimited File to Fixed width file	raghavan.aero	Shell Programming and Scripting	2	06-06-2007 02:44 PM
adding delimiter to a fixed width file	sumeet	Shell Programming and Scripting	2	03-21-2007 10:19 AM
Fixed Width file using AWK	alok.benjwal	UNIX for Dummies Questions & Answers	2	12-05-2005 11:39 AM

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