Padding with zeros. - Page 2

durden_tyler · #1 (**permalink**) 05-13-2009

If you have exactly 3 fields in the file, then:

Code:

$
$ cat file.csv
"100","100","ABC"
"100","200","ABC"
"100","300","ABC"
$
$ # awk
$ awk -F, '{gsub(/"/,""); printf("\"%s\",\"%07s\",\"%s\"\n",$1,$2,$3)}' file.csv
"100","0000100","ABC"
"100","0000200","ABC"
"100","0000300","ABC"
$
$ # or perl
$ perl -ne '{chomp; split /","/; printf("%s\",\"%07s\",\"%s\n",$_[0],$_[1],$_[2])}' file.csv
"100","0000100","ABC"
"100","0000200","ABC"
"100","0000300","ABC"
$

tyler_durden

limshady411 · #2 (**permalink**) 05-13-2009

Thanks Tyler, this does the trick!

ghostdog74 · #3 (**permalink**) 05-13-2009

if you have Python

Code:

#!/usr/bin/env python
import csv
filename = "file"
reader = csv.reader(open(filename))
writer = csv.writer( open("newfile.csv","wb"), quoting=csv.QUOTE_ALL)
for row in reader: 
    writer.writerow(row)

output

Code:

# ./test.py
# more newfile.csv
"100","0000100","ABC"
"100","0000200","ABC"
"100","0000300","ABC"

limshady411 · #4 (**permalink**) 05-18-2009

I don't have python, but thanks!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Help needed in padding leading zeros	jakSun8	Shell Programming and Scripting	12	07-02-2008 07:41 PM
Byte Padding	naan	High Level Programming	6	02-22-2007 05:09 AM
Padding zeros after removing commas in file	pranag21	HP-UX	1	11-09-2005 10:22 PM
Padding	vijaygopalsk	UNIX for Dummies Questions & Answers	2	06-27-2003 10:51 AM
Padding issues	informshilpa	UNIX for Advanced & Expert Users	2	03-01-2002 01:51 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: