Appending to file with new ID


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 1  
Appending to file with new ID

I have a file that looks like this:

Code:
 
1|A
2|B
3|C
...
...
100|A

I would like to take the last line in the file and add +1 to the number so
the output looks like this

Code:
 
 
1|A
2|B
3|C
...
...
100|XXX
101|A
102|B
103|C
...
...
200|XXX

Can somebody provide me with a command to do this?

Thanks in advance to all who help
# 2  
Not clear. Your explanation and example doesn't match at least for me.

the last line is 100|A. What you want to do with that? How the original lines are there on the output and what does the XXX means?
# 3  
Apologies, the original file should be 100|XXX

Basically I want to increment the first col with the next number and keep the rest of the line
# 4  
Is it one time activity? If you know the last number, it makes it simple

Code:
 awk -F\| '{a[NR+100]=$2;print} END {for (i in a) {print i FS a[i]}}' file

Let us know if you dont want hard coding last number (i.e. 100) and want to automate that.

Secondly, As of now, array loop is giving me the order as expected. but its not true for awk array. if you have gawk, it will come handy then.
# 5  
Code:
awk 'BEGIN{FS=OFS="|"}
  {a[++n] = $1; b[$1] = $2; print $0}
  END {for(i = 1; i <= n; i++) print a[n] + i, b[a[i]]}' file

Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #87
Difficulty: Easy
Windows 7 added PowerShell, a more powerful command-line shell and scripting language than the Command Prompt.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Appending content of a file to another file before a specific character

Hi there, i've got a file with this content $ cat file1 Matt Mar The other file has the same number of lines with this content: $ cat file2 20404=767294 23450=32427 is there a way with either using sed, awk or paste to insert the content of file1 before the "=" character? So... (3 Replies)
Discussion started by: nms
3 Replies

2. Shell Programming and Scripting

Removing part of a file name and appending into a single file

I have two files like ABC_DEF_yyyyymmdd_hhmiss_XXX.txt and ABC_DEF_yyyyymmdd_hhmiss_YYY.txt. The date part is going to be changing everytime. How do i remove this date part of the file and create a single file like ABC_DEF_XXX.txt. (8 Replies)
Discussion started by: varlax
8 Replies

3. Shell Programming and Scripting

Appending number of lines in the file to begining of the file

I am having 6 files named file1,file2....file6 and i need to append number of lines in each file to begining of the file. For example, If file 1 contains a b c d then after adding new line file1 should contain 4 a b c d Thanks in advance. (2 Replies)
Discussion started by: akhay_ms
2 Replies

4. Shell Programming and Scripting

appending the count of line in each file at head of each file

hello everybody, I have some files in directory.each file contain some data. my requirement is add the count of each line of file in head of each file. any advice !!!!!!!! (4 Replies)
Discussion started by: abhigrkist
4 Replies

5. Shell Programming and Scripting

searching a log file and appending to a .txt file

I'm new to shell scripting and am writing a script to help me log the free memory and hd space on a server. As of now, the script just runs 'df -h' and appends the output to a file and then runs 'top' and appends the output to a log file. What I want to do, is have the script also search the... (3 Replies)
Discussion started by: enator45
3 Replies

6. Shell Programming and Scripting

Appending in a file

Hi, I have file named Ex.txt which has the contents like this- <FndManagers> Mng={{PID|8819|LB}|75.000000|75.000000} Mng={{PID|25069|ML}|25.000000|0.000000} Mng={{PID|6034033|ML}|0.000000|25.000000} </FndManagers> I have a code which searches for the number 8819 and appends with the... (1 Reply)
Discussion started by: vinay123
1 Replies

7. Shell Programming and Scripting

appending to sed output of one file into the middle of file

hi, i have a file file1 file2 ----------- ----------------- aa bbb ccc 111 1111 1111 ddd eee fff 222 3333 4444 ggg hhh... (5 Replies)
Discussion started by: go4desperado
5 Replies

8. Shell Programming and Scripting

Reading specific contents from a file and appending it to another file

Hi, I need to write a shell script (ksh) to read contents starting at a specific location from one file and append the contents at specific location in another file. Please find below the contents of the source file that I need to read the contents from, File 1 -----# more... (5 Replies)
Discussion started by: dnicky
5 Replies

9. UNIX for Dummies Questions & Answers

appending a file

How do I append a header.txt file to files that start with xxx_*.? There are 20 different files that start with xxx_*. Thanks (1 Reply)
Discussion started by: chumba
1 Replies

10. UNIX for Dummies Questions & Answers

Appending out to a file

Hi, once again - Ok here it is: a).I used the touch command to create a file (touch directory.list) b).I then added this line: - date '+The date is %a %h %d, %Y %nIt is %I:%M %p' > directory.list -So that this date function would go at the top of my script c).Now I want to display a... (1 Reply)
Discussion started by: Astudent
1 Replies

Featured Tech Videos