adding order number in the output file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting adding order number in the output file
# 8  
Old 03-12-2007
Can you show your input and the output you require?
# 9  
Old 03-12-2007
Using a script

Code:
$ cat smp.csh
#!/bin/ksh
for i in `cat smp`
do
num=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\2/'`
chr=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\1/'`
(( num1 = num + 1 ))
print $chr$num1
done
$ ./smp.csh
maryu01002
johnm00004
peter02235
catmy66752
dfsd0001101
$

# 10  
Old 03-12-2007
i think you don't have Python, but anyhow., here's an alternative
Code:
#!/usr/bin/python
import re
for line in open("file"):
    found = re.findall("([a-zA-Z0-9]+)(\d{5})",line)[0]
    print "%s%05d" %(found[0], int(found[1]) + 1)

output:
Code:
# ./test.py #or ./test.py > outputfile 
ma01u01002
jo02nm00004
p01ter02235


Last edited by ghostdog74; 03-13-2007 at 12:49 AM..
# 11  
Old 03-12-2007
Hi
Try this using python:'input_file' is the in[put file and o/p will be in out_file
Save the below in a file(,say 'script_file') and Run " python script_file

Code:
s_list=open('input_file',"r").readlines()
f_out=open('out_file',"a+")
for each in s_list:
        init_part=each[:-6]
        f_out.writelines("%s%05d\n" %(init_part,(int(each[5:]) + 1)))
f_out.close()


Thnx,
Dennis
# 12  
Old 03-12-2007
Quote:
Originally Posted by mona
Using a script

Code:
$ cat smp.csh
#!/bin/ksh
for i in `cat smp`
do
num=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\2/'`
chr=`echo $i | sed 's/^\([a-zA-Z]*0*\)\([0-9]*\)$/\1/'`
(( num1 = num + 1 ))
print $chr$num1
done
$ ./smp.csh
maryu01002
johnm00004
peter02235
catmy66752
dfsd0001101
$

Great, it work...but one small error, if the name with number, the above will not work (bad number). For example "j0hnm", the script will display error message "bad number"
# 13  
Old 03-12-2007
Quote:
Originally Posted by happyv
Great, it work...but one small error, if the name with number, the above will not work (bad number). For example "j0hnm", the script will display error message "bad number"

anyone can help...if the name with number...the statement will be failed.
# 14  
Old 03-12-2007
Whats the problem with this code? I am getting correct result.
Code:
$ cat file
maryu01001
johnm00003
peter02234
catmy66751
$ awk '{
>    n = substr( $0, length( $0 ) - 4, 5 )
>    n=sprintf("%05d", ++n)
>    sub( /[0-9]{5}/, n , $0 )
>    print
> }' file
maryu01002
johnm00004
peter02235
catmy66752

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding user name to file, and then displaying new line number

Hi all - I'm completely stumped by a script I'm working on... The short version is I have a file called 'lookup' and in it are hundreds of names (first and last). I have a script that basically allows the user to enter a name, and what I need to have happen is something like this: Record... (8 Replies)
Discussion started by: sabster
8 Replies

2. Shell Programming and Scripting

Need Help in adding sequence number to a file

Hi All , I have a file which contains data(comma separated) in below format : 500,Sourav ,kolkata ,8745775020,700091 505,ram,delhi ,9875645874,600032 510 ,madhu ,mumbai ,5698756430 ,500042 515 ,ramesh ,blore ,8769045601 ,400092 I want to add unique sequence number at the start of each... (7 Replies)
Discussion started by: STCET22
7 Replies

3. Shell Programming and Scripting

Adding filename and line number from multiple files to final file

Hi all, I have 20 files (file001.txt upto file020.txt) and I want to read them from 3rd line upto end of file (line 1002). But in the final file they should appear to start from line 1. I need following kind of output in a single file: Filename Line number 2ndcolumn 4thcolumn I... (14 Replies)
Discussion started by: bioinfo
14 Replies

4. Shell Programming and Scripting

adding line number to *end* of records in file

Given a file like this: abc def ghi I need to get to somestandardtext abc1 morestandardtext somestandardtext def2 morestandardtext somestandardtext ghi3 morestandardtext Notice that in addition to the standard text there is the line number added in as well. What I conceived is... (4 Replies)
Discussion started by: edstevens
4 Replies

5. Shell Programming and Scripting

editing line in text file adding number to value in file

I have a text file that has data like: Data "12345#22" Fred ID 12345 Age 45 Wilma Dino Data "123#22" Tarzan ID 123 Age 33 Jane I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes: Data "1012345#22" Fred ID... (16 Replies)
Discussion started by: say170
16 Replies

6. Shell Programming and Scripting

Adding number before file extension

Hi , I have a file which has a line starts with $segment_name and has the below data source data $Segment_Name = 123.ABC.123.01.txt $Segment_Name = 123.ABC.ABC.txt $Segment_Name = 123.ABC.12A3.txtMy target data should be $Segment_Name = 123.ABC.123.01.txt $Segment_Name =... (2 Replies)
Discussion started by: shruthidwh
2 Replies

7. UNIX for Dummies Questions & Answers

Adding Sequence Number to file

Hi All, I need to create a script which checks for a particular file for eg.kumar1.txt. If kumar1.txt is already exist the script should increment the file name as kumar2.txt and so on. Please Advise. Thanks & Regards, Kumar66 (2 Replies)
Discussion started by: kumar66
2 Replies

8. Shell Programming and Scripting

How to split a file with adding sequence number and extension.

I have a file name -HRCFTSIN05PLA1602100430444444 my requirement is to split the file in 10000 count each file and to add sequence number.rch at the end of each file. output should be in this format HRCFTSIN05PLA160210043044444401.rch HRCFTSIN05PLA160210043044444402.rch... (4 Replies)
Discussion started by: abhigrkist
4 Replies

9. Shell Programming and Scripting

Counts a number of unique word contained in the file and print them in alphabetical order

What should be the Shell script that counts a number of unique word contained in a file and print them in alphabetical order line by line? (7 Replies)
Discussion started by: proactiveaditya
7 Replies

10. Shell Programming and Scripting

Adding a sequence number within a file

Can someone please help. I need to add a sequence number to the start of each line of a file. It needs to be 6 characters long. ie 000001 next line starts 000002 etc. (4 Replies)
Discussion started by: Dolph
4 Replies
Login or Register to Ask a Question