Changing one column of delimited file column to fixed width column

manneni prakash · #1 (**permalink**) 07-01-2008

Hi, Iam new to unix. I have one input file .

Input file :

ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3

I need output such that only first column should change to fixed width column of 15 characters of length.

Output File:

ID1<<12 spaces>>Name1~Place1
ID2<<12 spaces>>Name2~Place2
ID3<<12 spaces>>Name3~Place3

Thanks in advance.

zaxxon · #2 (**permalink**) 07-01-2008

Code:

awk -F"~" '{printf("%-15s%s~%s\n", $1,$2,$3)}' inputfile
ID1            Name1~Place1
ID2            Name2~Place2
ID3            Name3~Place3

manneni prakash · #3 (**permalink**) 07-01-2008

It works .............. Thanks Zaxxon

kingpeejay · #4 (**permalink**) 06-22-2009

please disregard this post of mine.thanks!

vidyadhar85 · #5 (**permalink**) 06-22-2009

this will also do

Code:

printf "%-15s%s~%s\n" $(tr '~' ' '<inputfile)

summer_cherry · #6 (**permalink**) 06-22-2009

Code:

nawk -F"~" '{printf("%-15s%s~%s\n",$1,$2,$3)}' yourfile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Comparing column of variable length anf fixed width file	manneni prakash	Shell Programming and Scripting	5	06-25-2008 01:46 AM
Replacing column with column of another file	manneni prakash	UNIX for Advanced & Expert Users	1	06-24-2008 11:27 PM
Replacing column with column of another file	manneni prakash	UNIX for Dummies Questions & Answers	1	06-24-2008 11:20 PM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
Replace 10th column with a new column--- Terriblly hurry	ahmedwaseem2000	Shell Programming and Scripting	2	09-06-2005 01:10 AM

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