Reindex or re-increment last field of txt file.

silenthands · #1 (**permalink**) 11-07-2007

I am using a database text file with a field that increments +1 with each new entry, occasionally if a entry is deleted the unique sequence is disrupted.

I am looking for a small script/function in sh and/or perl that would re index this.

Example of db file:

Name | Address | misc |number
Me|22 ave|another|1
you|33 rd|something|2
else|7|help|3
neighbor|22 long road||4

If a entry/record is deleted I might end up with this:

Name | Address | misc |number
Me|22 ave|another|1
you|33 rd|something|2
neighbor|22 long road||4

Which I would like to re-index to turn out like this:

Name | Address | misc |number
Me|22 ave|another|1
you|33 rd|something|2
neighbor|22 long road||3

Any help would rock.

Thankyou

Edit: To being with:
awk -F "|" '{print NR-1" "$NF}' filename.txt

Gives two parallel lines for comparison...

Almost there:
awk -F "|" '{$NF=NR-1; print NR-1 " " $NF}' filename.txt

Fixes it, now to figure out the substitue and put it in a nice perl function, which will be hard.

ranj@chn · #2 (**permalink**) 11-08-2007

Code:

awk -F "|" -f file.awk filename

where, file.awk contains

Code:

NR!=1 {
for (i=1;i<=NF;i++)
{
 if(NF==i)
 {
  if( $NF != NR-1) printf("%d\n", NR-1); else printf("%s\n", $NF );
 }
 else
 {
  printf("%s|", $i);
 }
}
}

NR==1 { print $0 }

silenthands · #3 (**permalink**) 11-08-2007

Perfect thank you

Even took care of the first line which was just headers and no numbers.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Increment userid in file	dejavu88	Shell Programming and Scripting	2	05-26-2008 06:11 PM
add increment field when first field changes	azekry	Shell Programming and Scripting	2	11-14-2005 04:21 PM
increment a Variable	cengiz	Shell Programming and Scripting	4	07-13-2005 06:31 AM
Append a field to the end of each line of a file based on searching another file.	ultimate	Shell Programming and Scripting	2	03-29-2005 11:21 AM
Increment counter in ksh	steiner	Shell Programming and Scripting	5	12-02-2003 08:10 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by