Padding with zeros.

sbasetty · #1 (**permalink**) 02-06-2007

Hi Friends,

I would like to left pad with "0's" on first column say (width six)
I have a large file with the format:

FILE:

1: ALFRED 84378 NY
8385: JAMES 88385 FL
323: SMITH 00850 TX

My output needs to be like:

000001: ALFRED 84378 NY
008385: JAMES 88385 FL
000323: SMITH 00850 TX

Thanks in advance for your help

vino · #2 (**permalink**) 02-07-2007

Code:

#! /bin/ksh

typeset -RZ 6 code

while IFS=':' read first rest
do
    code=${first}
    echo "${code}: ${rest}"
done < input.txt

anbu23 · #3 (**permalink**) 02-07-2007

Code:

while IFS=':' read first rest
do
    printf "%06d:%s\n" $first "$rest"
done< file

tayyabq8 · #4 (**permalink**) 02-07-2007

Another way:

Code:

awk -F: '{ printf "%06d: %s\n", $1,$2 }' input.txt

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

Hi all,

Referencing the awk statement here

Code:

awk -F: '{ printf "%06d: %s\n", $1,$2 }' input.txt

, I want to apply this concept to the 5th field, where I am padding 6 leading zeroes, and the rest of my fields stay the same. I tried the following:

Code:

awk -F, '{ printf "%06d, %s\n", $6,$7 }' test1.csv > test2.csv

but it won't output my first five fields or fields after the 6th field.

Please advise. Thanks much!
Lim

jim mcnamara · #6 (**permalink**) 05-13-2009

Code:

 echo "1 2 3 4 5 6 7 8 9" | awk '{ $6=sprintf("%06s", $6); print $0}'
1 2 3 4 5 000006 7 8 9

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

Thanks Jim. This looks like it would do the trick. I can't get it working with my code though. I started using this:

Code:

while IFS=',' read first rest
do
  printf "%07d,%s\n" $first "$rest" >> newfile.csv
done< file.csv

which will pad the first field. But I would like to pad the second field. How do I get the code above to pad the second? Thanks much!

Here's the input file:
"100","100","ABC"
"100","200","ABC"
"100","300","ABC"

Here's the desired output:
"100","0000100","ABC"
"100","0000200","ABC"
"100","0000300","ABC"

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