Search Results

for making a summary
I have a CSV file which is transformed to .DAT. I have an AWK file which is supposing to do the mapping of the DAT file. The code from the AWK file is the one below.

The...

I have found a solution. it looks like this:

BEGIN { FS=","; OFS="\t"; a["ODT"]=1;a["AGE"]=1;a["CDT"]=1;a["CO"]=1;
a["SEX"]=1;a["TIME"]=1;a["VALUE"]=1;a["COMMENT"]=1; }
NR==1 { ...

Is this what you mean:
replacing my code with your code below?


BEGIN
{
OFS="\t"
}

NR==1
{
$7="NUMB";
$8="STRING_COM";
$9="STRING_STATUS";
print $0;
next
} $8 != "c"
{...

the result is :

ODT AGE CDT CO SEX TIME NUMB STRING_COM STRING_STATUS
ODT AGE CDT CO SEX TIME NUMB STRING_COM STRING_STATUS
ODT AGE CDT CO SEX TIME NUMB STRING_COM STRING_STATUS

do you mean to change my code exactly like this:BEGIN {
FS = "," ;
OFS = " " ;
}
NR==1 {$7="NUMB";$8="STRING_COM";$9="STRING_STATUS"; print $0; next} $8 != "c" {$9=$8;...

Dear all,

I have a csv file which is transformed to .dat. I have an awk file which is supposing to do the mapping of the dat file. the code from the awk file is the one below.

The content of...