Return to Question

removed excessive whitespace to avoid horizontal scrolling

Source Link

edited Jul 1, 2014 at 14:02

252.3k
69
480
718

function ltrim(s) { sub(/^[ \t]+/, "", s); return s }
function rtrim(s) { sub(/[ \t]+$/, "", s); return s }
function trim(s)  { return rtrim(ltrim(s)); }

        function getfield( xml, fieldname) {
                i = index ( xml, "fieldName=\""fieldname"\"");
                if(i < 1){
                        ts = "";
                }
                else{
                        ts = substr( xml, i + length("fieldName=\""fieldname"\"") );
                        ts = substr( ts, index( ts, "value=\"" ) + length( "value=\"" ) );
                        ts = substr( ts, 1, index( ts, "\"")-1);
                        gsub(/&amp;/, "&", ts );
                        if ( index( ts, "," ) > 0 ) ts ="\""ts"\"";
                }
                return ts;
        }
BEGIN   { FS = "--------";OFS=",";}
 {sub(/..,[A-Z][A-Z]/, "CT-PT")}

        {
                orig = $0;
               # $7 = getfield(orig, "Modalities In Study");
                $9 = getfield(orig,"Subject Patients Sex");
                $10 = getfield(orig,"Modality Body Region");
                $11 = getfield(orig, "Patients Birth Date");
                $12 = getfield(orig, "Protocol Name");
                $13 = getfield(orig, "Timepoint ID");
                print;
         }

Everything is working great except for one thing. If iI place this print statement anywhere in the code, it loops in the whole Excel spreadsheet. So basically the print statement appears in every other row. I only want it to appear in the first row:

function ltrim(s) { sub(/^[ \t]+/, "", s); return s }
function rtrim(s) { sub(/[ \t]+$/, "", s); return s }
function trim(s)  { return rtrim(ltrim(s)); }

        function getfield( xml, fieldname) {
                i = index ( xml, "fieldName=\""fieldname"\"");
                if(i < 1){
                        ts = "";
                }
                else{
                        ts = substr( xml, i + length("fieldName=\""fieldname"\"") );
                        ts = substr( ts, index( ts, "value=\"" ) + length( "value=\"" ) );
                        ts = substr( ts, 1, index( ts, "\"")-1);
                        gsub(/&amp;/, "&", ts );
                        if ( index( ts, "," ) > 0 ) ts ="\""ts"\"";
                }
                return ts;
        }
BEGIN   { FS = "--------";OFS=",";}
 {sub(/..,[A-Z][A-Z]/, "CT-PT")}

        {
                orig = $0;
               # $7 = getfield(orig, "Modalities In Study");
                $9 = getfield(orig,"Subject Patients Sex");
                $10 = getfield(orig,"Modality Body Region");
                $11 = getfield(orig, "Patients Birth Date");
                $12 = getfield(orig, "Protocol Name");
                $13 = getfield(orig, "Timepoint ID");
                print;
         }

Everything is working great except for one thing. If i place this print statement anywhere in the code, it loops in the whole Excel spreadsheet. So basically the print statement appears in every other row. I only want it to appear in the first row:

function ltrim(s) { sub(/^[ \t]+/, "", s); return s }
function rtrim(s) { sub(/[ \t]+$/, "", s); return s }
function trim(s)  { return rtrim(ltrim(s)); }

function getfield( xml, fieldname) {
    i = index ( xml, "fieldName=\""fieldname"\"");
    if(i < 1){
      ts = "";
    }
    else{
       ts = substr( xml, i + length("fieldName=\""fieldname"\"") );
       ts = substr( ts, index( ts, "value=\"" ) + length( "value=\"" ) );
       ts = substr( ts, 1, index( ts, "\"")-1);
       gsub(/&amp;/, "&", ts );
       if ( index( ts, "," ) > 0 ) ts ="\""ts"\"";
    }
            return ts;
        }
BEGIN   { FS = "--------";OFS=",";}
 {sub(/..,[A-Z][A-Z]/, "CT-PT")}

        {
                orig = $0;
               # $7 = getfield(orig, "Modalities In Study");
                $9 = getfield(orig,"Subject Patients Sex");
                $10 = getfield(orig,"Modality Body Region");
                $11 = getfield(orig, "Patients Birth Date");
                $12 = getfield(orig, "Protocol Name");
                $13 = getfield(orig, "Timepoint ID");
                print;
         }

Everything is working great except for one thing. If I place this print statement anywhere in the code, it loops in the whole Excel spreadsheet. So basically the print statement appears in every other row. I only want it to appear in the first row:

Source Link

asked Jul 1, 2014 at 13:37

ryekayo

4.8k
10
46
67

Awk print problem

I have a code that takes values from a log file and populates them into an excel spreadsheet:

function ltrim(s) { sub(/^[ \t]+/, "", s); return s }
function rtrim(s) { sub(/[ \t]+$/, "", s); return s }
function trim(s)  { return rtrim(ltrim(s)); }

        function getfield( xml, fieldname) {
                i = index ( xml, "fieldName=\""fieldname"\"");
                if(i < 1){
                        ts = "";
                }
                else{
                        ts = substr( xml, i + length("fieldName=\""fieldname"\"") );
                        ts = substr( ts, index( ts, "value=\"" ) + length( "value=\"" ) );
                        ts = substr( ts, 1, index( ts, "\"")-1);
                        gsub(/&amp;/, "&", ts );
                        if ( index( ts, "," ) > 0 ) ts ="\""ts"\"";
                }
                return ts;
        }
BEGIN   { FS = "--------";OFS=",";}
 {sub(/..,[A-Z][A-Z]/, "CT-PT")}

        {
                orig = $0;
               # $7 = getfield(orig, "Modalities In Study");
                $9 = getfield(orig,"Subject Patients Sex");
                $10 = getfield(orig,"Modality Body Region");
                $11 = getfield(orig, "Patients Birth Date");
                $12 = getfield(orig, "Protocol Name");
                $13 = getfield(orig, "Timepoint ID");
                print;
         }

{print "Study Instance UID,Number of Series,Number of Instances, Exam Transfer Date,Exam Date,Subject Number,Modalities In Study,Upload Status,Subject Patients Sex,Modality Body Region,Patients Birth Date,Protocol Name,Timepoint"}

I am not sure why this occurs. I even tried placing this line right after function trim(s) { return rtrim(ltrim(s)); } but still keeps looping in the spreadsheet. Does anyone have any suggestions or might know why this occurs?

awk