Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

inserting uniq sequential numbers at the start of the file

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers inserting uniq sequential numbers at the start of the file
# 1  
Old 11-07-2005
inserting uniq sequential numbers at the start of the file
Hi Unix gurus,
I have a file. I need to insert sequential number at the starting of the file. Fields are delimited by "|". I know the starting number.


Example:

File is as follows

|123|4test|test
|121|2test|test
|x12|1test|test
|vd123|5test|test

starting number is : 120

output must be :

120|123|4test|test
121|121|2test|test
122|x12|1test|test
123|vd123|5test|test


Advance thanks for helping.

Jingi
# 2  
Old 11-07-2005
awk 'BEGIN{n=120}{printf("%s%s\n",n++,$0)}' infile > outfile

Cheers
ZB
# 3  
Old 11-08-2005
Quote:
Originally Posted by zazzybob
awk 'BEGIN{n=120}{printf("%s%s\n",n++,$0)}' infile > outfile

Cheers
ZB

Can 120 be a varaible? I mean

variable=12

awk 'BEGIN{n=$variable}{printf("%s%s\n",n++,$0)}' infile > outfile

??

The aboe statement doesn't work if it is variable..what is the work around?
# 4  
Old 11-08-2005
Quote:
Originally Posted by jingi1234
Can 120 be a varaible? I mean

variable=12

awk 'BEGIN{n=$variable}{printf("%s%s\n",n++,$0)}' infile > outfile

??

The aboe statement doesn't work if it is variable..what is the work around?
Code:
nawk -v n=120 '{printf("%s%s\n",n++,$0)}' infile > outfile

# 5  
Old 11-08-2005
Data
What if the file has "tab" [\t] as a delimter? what should i change in the nawk?

Please help
Last edited by jingi1234; 11-17-2005 at 12:22 PM..
# 6  
Old 11-17-2005
Gurus,
Please help
# 7  
Old 11-19-2005
Quote:
Originally Posted by jingi1234
What if the file has "tab" [\t] as a delimter? what should i change in the nawk?

Please help
'man nawk' should help.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Replace groups into sequential numbers

I have a file that looks like this: n1 1 n2 1 n3 1 n4 3 n4 3 n2 5 n2 5 n2 5 n2 5 n3 5 n3 5 n4 6 n7 6 that is a name followed be a descriptive number. I want to make these numbers sequential starting from 0 but without changing the "neighbours" each name belongs to. So the above... (3 Replies)
Discussion started by: FelipeAd
3 Replies

2. Shell Programming and Scripting

Inserting new line if two sequential lines begin with the same string

Hi I have a file like this: Peter North Mary Peter North Peter Borough Mary I need there to put 'X' (or anything) on a new line between the two lines where 'Peter' begins the line. There will be many matches to this string, but they will always begin with 'Peter'. Ie, the resulting... (2 Replies)
Discussion started by: majormajormajor
2 Replies

3. UNIX for Dummies Questions & Answers

[Solved] awk solution to add sequential numbers based on a word

Hi experts, I've been struggling to format a large genetic dataset. It's complicated to explain so I'll simply post example input/output $cat input.txt ID GENE pos start end blah1 coolgene 1 3 5 blah2 coolgene 1 4 6 blah3 coolgene 1 4 ... (4 Replies)
Discussion started by: torchij
4 Replies

4. UNIX for Dummies Questions & Answers

Inserting a sequential number into a field on a flat file

I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number. As an example, let's assume there are only 4 fields in the file: A,A,,32 A,A,,27 A,B,,43 C,C,,354 If I wanted to amend the 3rd field in this way my... (2 Replies)
Discussion started by: BristolSmithy
2 Replies

5. Shell Programming and Scripting

Sequential numbers

Hi All, I am looking for a simple way to write numbers to a file sequentially starting from 1 and ending on a specified upper limit. Example of the output file is below Example 1 2 3 4 5 . . . . 1000 please let me know the best way to do it. (10 Replies)
Discussion started by: Lucky Ali
10 Replies

6. Shell Programming and Scripting

Rename files in sub directories with sequential numbers

I can rename a file with sequential numbers from 1 to N with this script: num=1 for file in *.dat;do mv "$file" "$(printf "%u" $num).txt" let num=num+1 done The script begins with renaming a some.dat file to 1.dat.txt and goes on sequentially renaming other DAT files to... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

7. Programming

Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX

Writing a Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX I have over the years come across the same issue a couple of times, and it normally is that the read speed on SAN is absolutely atrocious when doing non-sequential I/O to the disks. Problem being of... (7 Replies)
Discussion started by: vrghost
7 Replies

8. Shell Programming and Scripting

Shell Scripts (Renaming file names with sequential numbers)

Hi there, Firstly, I have no experience with shell scripts so would really appreciate some help. I have the following shell script that is causing some problems: moveit() { && set -x if then DOUBLE_DELIVERY=$(grep... (6 Replies)
Discussion started by: thebeno
6 Replies

9. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

I have a text file in the following format .... START 1,1 2,1 3,1 .. .. 9,1 10,1 END .... I want to change to the output to .... START 1,1 2,1 3,1 .. (4 Replies)
Discussion started by: VNR
4 Replies

10. Programming

Reading special characters while converting sequential file to line sequential

We have to convert a sequential file to a 80 char line sequential file (HP UX platform).The sequential file contains special characters. which after conversion of the file to line sequential are getting coverted into "new line" or "tab" and file is getting distorted. Is there any way to read these... (2 Replies)
Discussion started by: Rajeshsu
2 Replies
Login or Register to Ask a Question