Merging fields within a file

[jasperx]

I have a well structured comma separated file which has approximately 20 fields... some may have a few less. I would like to "merge" all of the fields $15 through NF into a single field. What I have written is working on my header line but blowing up on the subsequent lines... most of which start,,, with some empty fields. Here is my code so far:
#!/bin/awk -f

BEGIN {
FS=","
OFS=","
RS="\n"
ORS="\n"
}

{ #Loop through printing first 14 fields separated by commas
for (i=1; i<=NF; i++){
if (i<15){
printf(&quot;%s,&quot;, $i)
}
else{
printf(&quot;%s&quot;, $i)
}
}
}

 

[vgersh99]

something like that:

BEGIN {
FS=OFS=&quot;,&quot;
FSpivot=15
}
{
for(i=1; i<=NF; i++)
printf(&quot;%s&quot;, (i < FSpivot) ? i OFS : i);
print &quot;&quot;;
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[jasperx]

Maybe something like but I am not getting it to work...FSpivot probably needs to be $FSPivot? Still no joy... my text shows the contditional statement a little different but that didn't work either.
All are getting this message:
awk: syntax error at source line 2
context is
>>> ? <<<

Here is a cut and paste of that code again:

BEGIN { 
  FS=OFS="," 
  FSpivot=15 
}
{
  for(i=1; i<=NF; i++) 
    printf(&quot;%s&quot;, (i < FSpivot) ? i OFS : i); 
  print &quot;&quot;; 
}

 

[PHV]

Try something like this:

BEGIN{FS=OFS=",";FSPivot=15}
{for(i=1;i<=NF;++i)
  if(i<FSPivot) printf(&quot;%s,&quot;,$i); else printf(&quot;%s&quot;,$i)
 printf &quot;\n&quot;
}

Hope This Help
PH.

 

[vgersh99]

works fine with Solaris' 'nawk' and MKS's awk.

If on Solaris try with 'nawk'.

If not on Solaris, PHV's alternative should be sufficient.

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+