Add comma to integer using AWK

Nutter · #1 (**permalink**) 08-24-2008

Srr for being pain her
let say i have a data in a file like this

1@1000
2@2000
4@4000
5@7770
6@8998
7@80008

i am a newbie in Unix
i need to add a comma to integer using AWK function. for example, 1,000 or 80,008
how can i do that

ps. i'm using bash shell

fpmurphy · #2 (**permalink**) 08-25-2008

Assuming your locale supports thousands separators (and many do not) and you are using gawk (GNU awk) and not awk or nawk the following will do what you want

Code:

$ cat t.awk
{ printf "%d@%'d\n", $1, $2 }
$
$ cat file
1@1000
2@2000
4@4000
5@7770
6@8998
7@80008
$
$ gawk -F@ -f t.awk file
1@1,000
2@2,000
4@4,000
5@7,770
6@8,998
7@80,008
$

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Cannot store integer value	bennichan	Shell Programming and Scripting	5	04-10-2008 02:20 PM
get integer part	ericaworld	Shell Programming and Scripting	3	05-29-2007 03:16 PM
how to pass integer	ramneek	IP Networking	1	08-25-2005 08:40 AM
awk or grep for integer only	apalex	UNIX for Dummies Questions & Answers	5	09-01-2004 01:38 PM
add comma	alisevA3	UNIX for Dummies Questions & Answers	3	10-18-2002 09:29 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: