Delimited fields and formating - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Delimited fields and formating

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Converting Space delimited file to Tab delimited file	jeevs81	UNIX for Dummies Questions & Answers	16	02-26-2009 02:49 AM
Sort the fields in a comma delimited file	swethapatil	UNIX for Dummies Questions & Answers	3	10-24-2008 07:16 AM
combining fields in two text fields	shocker	Shell Programming and Scripting	3	01-16-2008 11:27 AM
formating output	Krrishv	Shell Programming and Scripting	20	02-02-2007 09:39 AM
Converting Tab delimited file to Comma delimited file in Unix	charan81	Shell Programming and Scripting	22	01-20-2006 09:24 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

04-22-2009

s_adu

Registered User

Join Date: Apr 2009

Posts: 8

Delimited fields and formating

Hi

I am new to scripting. I have a file with following data

245|3|20090303456|3456
5072|34|20090304453|3546
245|28|20090304453|3547
5074|43|20090304453|3548

I want to format the file as below

245| 3|20090303456|3456
5072|34|20090304453|3546
245|28|20090304453|3547
5074|43|20090304453|3548

The main reason I want to do this is becase I want to sort the file using sort -n based on 1st 2 fields

If I do not reformat as above then sort -n will give

245|28|20090304453|3547
245|3|20090303456|3456
5072|34|20090304453|3546
5074|43|20090304453|3548

What I actually want is

245|3|20090303456|3456
245|28|20090304453|3547
5072|34|20090304453|3546
5074|43|20090304453|3548

Please help me.

Thanks and Regards
Adarsh

Bookmarks

Tags

awk

« Problem establishing Connection on the LAN | within shell script send expect and if else »

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 06:50 PM.