Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help require with counter

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help require with counter
# 1  
Old 12-21-2012
Help require with counter
I have this file

Code:


Code:



1801,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,VOE,,,,,,,,,,,,,,,
1802,A1,2012-12-16 15:59:59.995,id2_3,ab=,phoneX1-01,BL,,,,,,,,,,,,,,,
1803,A1,2012-12-16 15:59:59.995,id2_3,ab,phone300,BL,,,,,,,,,,,,,,,
1804,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,al,,,,,,,,,,,,,,,
1805,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
1806,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,id,,,,,,,,,,,,,,,
1807,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
1808,A1,2012-12-16 15:59:59.995,id2_3,ab,phone100,al,,,,,,,,,,,,,,,
1809,A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,
1810,A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,


the first column gives the count number of that row..... it begins from 1,2,3...


the file looks before processing like mentioned below


Code:


Code:



A1,2012-12-16 15:59:59.995,id2_3,ab=,phoneX1-01,BL,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phone300,BL,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,al,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,id,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phone100,al,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,
A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,

Last edited by nikhil jain; 12-21-2012 at 02:57 AM.. Reason: confidential
# 2  
Old 12-21-2012
Nikhil, the answer is available in your last thread

---------- Post updated at 02:01 AM ---------- Previous update was at 01:56 AM ----------

You find that difficult try this,

Code:
# awk '{print NR","$0}' file
1,abc
2,123
3,def
4,ghi
5,567

343564@01HW294908 ~/unix
# cat file
abc
123
def
ghi
567

# 3  
Old 12-21-2012
sathya

i wanted to know how can i add a counter as first column to my above mentioned file.... previous error got rectified.....

---------- Post updated at 12:36 PM ---------- Previous update was at 12:33 PM ----------

thanks a ton satya.... Smilie
it worked.. Smilie
ur awesome... Smilie
it was basic and i was struggling... :P
# 4  
Old 12-21-2012
This is how you have to do
Code:
# awk '{print NR","$0}' file
1,A1,2012-12-16 15:59:59.995,id2_3,ab=,phoneX1-01,BL,,,,,,,,,,,,,,,
2,A1,2012-12-16 15:59:59.995,id2_3,ab,phone300,BL,,,,,,,,,,,,,,,
3,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,al,,,,,,,,,,,,,,,
4,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
5,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,id,,,,,,,,,,,,,,,
6,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneX1-01,al,,,,,,,,,,,,,,,
7,A1,2012-12-16 15:59:59.995,id2_3,ab,phone100,al,,,,,,,,,,,,,,,
8,A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,
9,A1,2012-12-16 15:59:59.995,id2_3,ab,phone101,id,,,,,,,,,,,,,,,

This User Gave Thanks to sathyaonnuix For This Post:
nikhil jain
# 5  
Old 12-21-2012
as per understanding he don't want sequence number in the first column.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. IP Networking

Samba ha configuration require

I HAVE TO DESIGN TWO NODE SAMBA HA SERVER, TO DO THIS I NEED YOUR HELP, HOW CAN CONFIGURE SUCH SCENARIO? REGARDS PRAMOD INGOLE (4 Replies)
Discussion started by: pramod_ingole
4 Replies

2. Shell Programming and Scripting

sed help require

sed 's/abcd/$variable/g' abcd_calls > $variable_calls This is the statement i am trying which has 2 errors in it. 1st- sed 's/abcd/$variable/g' is changing abcd to $variable in the file abcd_calls ,I want it to convert abcd into the string value given by user through read command, taking... (1 Reply)
Discussion started by: learnbash
1 Replies

3. Shell Programming and Scripting

Require help to sort string

Hi Folks, Currently am working with 10g db. I want to sort the below o/p. Current output: ============ SQL> select partition_name from user_tab_partitions where table_name='USER_AUDIT'; PARTITION_NAME ------------------------------ PARTMAX PART_AUDIT_NOV02 PART_AUDIT_NOV08... (4 Replies)
Discussion started by: sathik
4 Replies

4. UNIX and Linux Applications

Getmail help require

Hi all, I am retrieving mail from live mail server to local mail server. I want to know that, how can i exclude some peoples from getmail domain retrival. verbose = 1 read_all = true delete_after = 30 message_log = ~/.getmail/log type = MultidropIMAPRetriever server = mail.abc.com... (0 Replies)
Discussion started by: jagnikam
0 Replies

5. Solaris

SMC require a password

Launching for the first time Solaris Management Console. Management Tools - This Computer - System Status - System Information. A window with info appear: In the right side: Solaris Management Console Server: 127.0.0.1 User Name: Root (Already written. And under it Password: (need typing).... (1 Reply)
Discussion started by: Xcislav
1 Replies

6. Shell Programming and Scripting

Require Help for Shell Script

Hi friends, i am trying to print warning for partition size which exceed limit of 90% & other are ok. i m using below command which print partition which exceed 90% # df -h | sort -k5 | head -1 | awk 'END{ print $1" :- Not Having more space on This Partition"}' i want to print... (14 Replies)
Discussion started by: jagnikam
14 Replies

7. Shell Programming and Scripting

Regarding use and require keywords

Hi, what is the difference between use and require keywords in Perl. What is the significance of these lines (what it mean, what is the use of this) #!/usr/bin/perl -w // In Perl script.... #!/bin/ksh //In shell script..... Thanks Sweta (2 Replies)
Discussion started by: sweta
2 Replies

8. UNIX for Dummies Questions & Answers

require help about cut command

hi, im trying to cut the file using cut command in unix . the problem is i want to input the chacter list from another file and then using the postioins specified in this file i want to cut another file. for eg. cut -c(here i want to use a list being read from a file) listdata(this is the file i... (2 Replies)
Discussion started by: vikramchots
2 Replies

9. Solaris

Command to require OS info

Hi, I am new to UNIX environment. Can anybody tell me how can I check whether my OS is 32bit or 64bit? Regards, Malay Mary (4 Replies)
Discussion started by: malaymaru
4 Replies

10. Shell Programming and Scripting

require in first line

I have a website with a lot of php files. I need to to have the line (where "requiredfile.php"' should be a valid reference to the requiredfile.php in the top directory): require "requiredfile.php" as first line in every php file. The requiredfile.php will be in the top dir and the line I... (2 Replies)
Discussion started by: ibidris2003
2 Replies
Login or Register to Ask a Question