Organizing columns with AWK

[Guest_imported]

Hello all...new to AWK and trying to learn, so help would be appreciated here Here's my problem:

File1 has 3 columns of data delimitted by quotes. I need to grab the middle column and append it to file2 in the form of 6 columns in 6E13.5 format.

I'm not sure if AWK is even the right command to be looking at, so any other ideas would be great.

Thanks!

 

[Krunek]

Hi gpburdell01!

I didn't quite understand your question, but I give you some suggestions. You can grab second column of file delimitted by quotes with this awk example

BEGIN  { FS = "'" }

{ print $2 > "file2" }

or this awk command

awk -F' '{ print $2 }' inputfile > file2

You can also post an example of your data.

Bye!

KP.

 

[CaKiwi]

Maybe this is what you want?

BEGIN {FS="'"}
{
printf("%13.5e",$2)
ix++
if (ix == 6) {
printf("\n&quot
ix = 0
}
}
END{ printf("\n&quot }

If not, post some sample input data and the output you expect.

CaKiwi