To increment the values from the file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To increment the values from the file
# 1  
Old 06-14-2011
To increment the values from the file

Hi

I have the file called "file.txt" which contains the following output
Code:
$cat file.txt
sandy
<version>1</version>
karen
<version>2</version>
Rob
<version>3</version>
peter
<version>4</version>

i want to write a command which will add the value 1 to the digits and show the output like this.
Code:
sandy
<version>2</version>
karen
<version>3</version>
Rob
<version>4</version>
peter
<version>5</version>

I have tried using some commands but it seems it is not working or i think i am wrong somewhere Smilie.
Code:
$ cat file.txt | grep "<version>" | sort -r | uniq | while read line
do
n=`echo $line | cut -f2 -d"<" |cut -f2 -d">"`
nn=`expr $n + 1`
newb="<version>$nn</version>"
sed 's;'${line}';'${newb}';g' file.txt >> file1.txt
mv -f file1.txt file.txt
done

Please help me resolving this problem.

Regards
Siddharth

Last edited by Franklin52; 06-14-2011 at 06:10 AM.. Reason: Please use code tags
# 2  
Old 06-14-2011
Code:
bash-3.00$ nawk -F"[<|>]" ' { if($2=="version") {printf("<%s>%d<%s>\n", $2,$3+1,$4)} else {print $0}}' /tmp/myfile
sandy
<version>2</version>
karen
<version>3</version>
Rob
<version>4</version>
peter
<version>5</version>

# 3  
Old 06-14-2011
Thanks a lot. Its working fine..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check increment values in column

Gents, I have a file where i would like to check the constant increment by 2 in column 2. 5450 1000 5450 1002 5450 1004 5450 1006 5465 1000 5465 1002 5465 1006 5465 1008 5550 1002 5550 1004 5550 1006 5550 1008 6830 1000 6830 1002 6830 1008 6830 1010 (6 Replies)
Discussion started by: jiam912
6 Replies

2. Shell Programming and Scripting

Increment Column having Alphanumeric value in file

I want to replace a column(first and last) having an alphanumeric value in a file. Requirement : 1)All values in a Column must be unique and contain an incremented pattern “HCTV0096” for first column and “cafefeca0090” for last column 2)for uniquely identifying each value in column Numeric part... (6 Replies)
Discussion started by: ketanraut
6 Replies

3. Shell Programming and Scripting

Need a REGEX to increment the file number of a pdf file

Hello, I have a few thousand .pdf files in various folders each have a naming scheme like this: 006_-_Titled_Document_#34_-_September-25-2011-side-1.pdf In each folder, the number system starts at 001 (as you see on the far left of the file name), and then ends at 999 (maximum .pdf files).... (4 Replies)
Discussion started by: Marcus Aurelius
4 Replies

4. Shell Programming and Scripting

Increment value in text file

Hi Guys, I am new to shell programing, I have a csv file which has 50k records and I have got the requirement to increment the value in second column after each 5000 records. for example below A,B,C,D //Header 1,1,London,UK 1,1,Manchester,UK 1,1,Glasgow,UK . . . 1,1,Newyork,USA... (7 Replies)
Discussion started by: rizzu1555
7 Replies

5. Shell Programming and Scripting

Need to increment number in data file

Hello, I have an Excel spreadsheet with the following data: Refntns3_1 char 30 Ref H77 nt codon 1 Reference H77 Nucleotide Codon 1 -- Codns3_1 char 30 Obs Nucleotides codon 1 Observed Nucleotides Codon 1 ... (2 Replies)
Discussion started by: deneuve01
2 Replies

6. Shell Programming and Scripting

Increment Numbers in File

Hello, I have a text file withe some records 20121031|5 20121030|3 20121029|1 20121028|4 20121027|6 I want to search for a patten with '20121030' and then increment the second part of the delimiter i.e. 3 by 1 to make it 4 to look like 20121031|5 20121030|4 20121029|1 20121028|4... (7 Replies)
Discussion started by: pparthiv
7 Replies

7. Shell Programming and Scripting

Increment a value in a configuration file.

Experts, I would appreciate if someone took the time to express there opinion /approach in creating a new change daily to a configuration file. I create a new log file each day and I wish to have a browser based reader display the new file. To achieve this I would need to create a new... (2 Replies)
Discussion started by: jaysunn
2 Replies

8. Shell Programming and Scripting

File existence and increment

count=0; while read line; do ] && let count=count+1; done < file_name.txt echo echo "$count of 10 files found " echo The scenario is a follows : I have a file which contains a list of filenames present in particular directory . I am checking fo the existence of the file and... (5 Replies)
Discussion started by: ultimatix
5 Replies

9. Shell Programming and Scripting

Check file and increment

My scripts excepts 4 files ABCD_01 ABCD_02 ABCD_03 ABCD_04 I want to check for these files , and increment counter one by one . at the end i would like to echo as 4 of 4 expected instances of file found . I tried something like thsi $counter =1 if counter=counter+1 i need... (5 Replies)
Discussion started by: ultimatix
5 Replies

10. Shell Programming and Scripting

Increment userid in file

Hello, does anyone know how to increment a userid(number) written in any scripting language that works on a shell? For example: I have a HTML file in this format: userid: name: telephone: Every time I execute my script it adds the same fields, except with the userid incremented. Like... (2 Replies)
Discussion started by: dejavu88
2 Replies
Login or Register to Ask a Question

Featured Tech Videos