Improving the AWK skills

awkscriptingtext processing

This program works as I intended but I feel like I used some clumsy methods to get the out put I desired(especially with my use of print commands and variable declarations)

Could some one improve this script so I can see where I could improve?
Does some one want to show me some crazy bummed version of this?
Is setting variables in the BEGIN block which "runs every line !@#!#@!" how you are supposed to set a variable in AWK?

#!/usr/bin/awk -f
BEGIN{
FS=",";
recordsCursor=1;
number=0;
#spacer="_";
#copies=3;
}
{
    while(number++ <=copies){
        while(recordsCursor <= NF){
            if(recordsCursor==1){
            printf($recordsCursor);
            printf(spacer);
            printf("%.3d,",number);
            }else if(NF != recordsCursor){
                printf("%s," , $recordsCursor);
                }else{
                printf("%s" , $recordsCursor);
                }
        recordsCursor++;
        }
    recordsCursor=1;
    print "";
    }
print "";
number=0;
}

Command: ./test.awk -v copies=3 -v spacer=_ input

Given input:

madison_Leaderboard_728x90,728x90,Leaderboard ads for Madison,no,,,,,,,_blank,image,web
madison_Bullseye_300x250,300x250,Bullseye ads for Madison,no,,,,,,Bullseye,_blank,image,web
madison_Button_155x155,155x155,Button ads for Madison,no,,,,,,,_blank,image,web

Correct output:

madison_Leaderboard_728x90_001,728x90,Leaderboard ads for Madison,no,,,,,,,_blank,image,web
madison_Leaderboard_728x90_002,728x90,Leaderboard ads for Madison,no,,,,,,,_blank,image,web
madison_Leaderboard_728x90_003,728x90,Leaderboard ads for Madison,no,,,,,,,_blank,image,web
madison_Leaderboard_728x90_004,728x90,Leaderboard ads for Madison,no,,,,,,,_blank,image,web

madison_Bullseye_300x250_001,300x250,Bullseye ads for Madison,no,,,,,,Bullseye,_blank,image,web
madison_Bullseye_300x250_002,300x250,Bullseye ads for Madison,no,,,,,,Bullseye,_blank,image,web
madison_Bullseye_300x250_003,300x250,Bullseye ads for Madison,no,,,,,,Bullseye,_blank,image,web
madison_Bullseye_300x250_004,300x250,Bullseye ads for Madison,no,,,,,,Bullseye,_blank,image,web

madison_Button_155x155_001,155x155,Button ads for Madison,no,,,,,,,_blank,image,web
madison_Button_155x155_002,155x155,Button ads for Madison,no,,,,,,,_blank,image,web
madison_Button_155x155_003,155x155,Button ads for Madison,no,,,,,,,_blank,image,web
madison_Button_155x155_004,155x155,Button ads for Madison,no,,,,,,,_blank,image,web

Best Answer

awk -v copies=3 -v spacer=_ '
  BEGIN {OFS=FS=","} 
  {
    field1 = $1
    for (i=1; i <= copies+1; i++) {
      $1 = sprintf("%s%s%03d", field1, spacer, i)
      print
    }  
    print ""
  }
'

This takes advantage of awk recalculating $0 if any of the fields change value.

Related Solutions

Bash – Strategy to extract movies’s name from this ununiform dataset

Using gawk and assuming that the year always ends the record:

awk -F"[0-9]{4}$" '{print $1}' movies

Awk: Extracting a fixed number of rows where the last row number may vary

This is not answering your question,
but it solves the problem you are trying to solve, in a completely different way:

The full command is this (see below for example output):

ps -o comm,%cpu,%mem --sort -%cpu -A | head -6

I will describe the parts of it:

using ps to have more control about the output
Printing only the three columns we need with -o comm,%cpu,%mem
Make ps sort the data internally --sort -%cpu, by CPU, reverse.
List all processes with -A
Show the header and the first 5 lines of the result by | head -6

The output is similar to the output of your first command:

$ ps -o comm,%cpu,%mem --sort -%cpu -A | head -6
COMMAND         %CPU %MEM
firefox          8.9 15.5
Xorg             1.3  5.6
parcellite       0.3  1.6
compiz           0.2  1.8
konsole          0.1  0.9

The process ps is listed in the full list - one could exclude it based on the parent PID.

If we want to exclude top processes elsewhere, we can do that based on the command name.

The -A selecting all processes would be replaced by -N ...:

ps ... -N --ppid $$ -C top

As we now need to exclude processes, we use -N to select all others processes than the ones we match.

To exclude ps, we use that it has the current interactive shell as parent process, so it will have the parent pid, PPID of the shell. The PID of the current shell is $$.
So --ppid $$ matches all child processes of the current shell, and we know that there will be only one, ps.

We want to also exclude the top processes that may run on other displays on the same machine. We do that by matching the command name with -C top.

The full command with excluding the ps process itself (and only this) and all top processes would be:

ps -o comm,%cpu,%mem --sort -%cpu -N --ppid $$ -C top | head -6

Best Answer

Related Solutions

Bash – Strategy to extract movies’s name from this ununiform dataset

Awk: Extracting a fixed number of rows where the last row number may vary

Related Question