Padding zeros after removing commas in file

pranag21 · #1 (**permalink**) 11-09-2005

Hi Gurus,

There is a ASCII file in which a comma is used as a seperator for the amount field when the amount exceed seven digits: e.g. 0001300,000. Now, this comma needs to be removed from this field, after padding leading zeros (to maintain the ASCII positions) e.g. 00001300000. Could anyone post a detailed solution which can handle this requirement?. There are multiple records in the file which fall under this category.

Thanks for your help

Prakash

Ygor · #2 (**permalink**) 11-09-2005

This is gnu sed....

Code:

$ echo "0001300,000" | sed -r 's/([0-9]{7}),([0-9]{3})/0\1\2/'
00001300000

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Padding with zeros.	sbasetty	Shell Programming and Scripting	10	05-18-2009 07:09 PM
Help needed in padding leading zeros	jakSun8	Shell Programming and Scripting	12	07-02-2008 07:41 PM
Removing leading zeros from a variable	toshidas2000	Shell Programming and Scripting	6	02-27-2008 01:13 PM
Removing empty spaces and adding commas	jazz	High Level Programming	4	11-13-2006 09:54 AM
removing commas from text file	hcclnoodles	UNIX for Dummies Questions & Answers	6	03-26-2003 04:43 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