Use Awk to Insert 0 padded Incrementing number in lines that contain a pattern – SEO

Since you are mentioning potentially processing the markdown in the table, ruby (or perl) is going to allow the table to be capture as a fully processable, sortable data element.

Here is an example that produces your desired output:

ruby  -e '
$<.read.scan(/(A[sS]+?)(^|[sS]+z)/){|b1,b2|
    puts b1        # the non-table part
    data=b2.split(/R/)  # second capture is the table part
    puts data[..1].join("n")    # the two line header
    puts data[2..].map.with_index(1){|l, i|    # this deals with the table data
        row=l.split("|")
        ([sprintf("%s.%03d", row[0], i)]+row[1..]).join("|")
    }
}
' file

Or use a split with a look ahead instead of a multi-line regex:

ruby -e '
$<.read.split(/(?=^|s+w+s+|)/,2).each_slice(2){|b1,b2|
    puts b1        # the non-table part
    data=b2.split(/R/)  # second split is the table part
    puts data[..1].join("n")    # the two line header
    puts data[2..].
        map{|l| l.split("|")}.
        map.with_index(1){|row, i|    
        ([sprintf("%s.%03d", row[0], i)]+row[1..]).join("|")
    }
}
' file

Either prints:

Last Updated: Mar 15 2023

- Score: cumulative of benchmarking tools.
- KiB: total size of the page.
- Stats: metrics related to the page.

| Score | KiB | Stats |
| --- | --- | --- |
227.001| Mathematics | 9 | search,seo 
038.002| Top Games | 2391 | search,seo,cookies 
136.003| Top Programming Languages | 219 | cookies

Here is the same but sorted by the existing first column:

ruby -e '
$<.read.split(/(?=^|s+w+s+|)/,2).each_slice(2){|b1,b2|
    puts b1        # the non-table part
    data=b2.split(/R/)  # second split is the table part
    puts data[..1].join("n")    # the two line header
    puts data[2..].
        map{|l| l.split("|")}.       # split into cells
        sort_by{|row| row[0].to_f}.  # sort by digits in col 1
        map.with_index(1){|row, i|    
        ([sprintf("%s.%03d", row[0], i)]+row[1..]).join("|")
    }
}
' file

Prints:

Last Updated: Mar 15 2023

- Score: cumulative of benchmarking tools.
- KiB: total size of the page.
- Stats: metrics related to the page.

| Score | KiB | Stats |
| --- | --- | --- |
038.001| Top Games | 2391 | search,seo,cookies 
136.002| Top Programming Languages | 219 | cookies 
227.003| Mathematics | 9 | search,seo 

Or by the third column:

ruby -e '
$<.read.split(/(?=^|s+w+s+|)/,2).each_slice(2){|b1,b2|
    puts b1        # the non-table part
    data=b2.split(/R/)  # second split is the table part
    puts data[..1].join("n")    # the two line header
    puts data[2..].
        map{|l| l.split("|")}.       # split into cells
        sort_by{|row| row[2].to_f}.  # sort by digits in col 3
        map.with_index(1){|row, i|    
        ([sprintf("%s.%03d", row[0], i)]+row[1..]).join("|")
    }
}
' file

Prints:

Last Updated: Mar 15 2023

- Score: cumulative of benchmarking tools.
- KiB: total size of the page.
- Stats: metrics related to the page.

| Score | KiB | Stats |
| --- | --- | --- |
227.001| Mathematics | 9 | search,seo 
136.002| Top Programming Languages | 219 | cookies 
038.003| Top Games | 2391 | search,seo,cookies

etc…