Shell Programming and Scripting

Hello,

Here is another one. The file type is almost same, many lines and many fields. What I need to do is to extract each line of old file and make it a new file, and in the new file, the field1 will be file name and the rest of field will be transpose to line.

Say,
1, field1 field2 field3 ...
2, field1 field2 field3 field4 ...
.
.

and output:
1, 'contants of field1'.txt:
field2
field3
.
.
.
2, 'contants of field1'.txt:
field2
field3
field4
.

Thanks in advance,

what have you tried so far?

Hi vgersh99,

for the first question, I tried your code that worked perfectly. For this one, I didn't get any reply yet. I thought awk and/or sed will work.

Thanks,

what have you tried so far?

I don't know what to do, but tried copy/paste and transpose. Any idea?

You really need to start with your own ideas......

Your description is not clear - I don't know what you're after.
Also please start using code tags when posting data/code samples!
Here's something to start with - good luck!

nawk -f ss.awk myFile

ss.awk:

Code:

BEGIN {
  FS=OFS="\t"
}
{
  f1=substr($1,index($1,",")+1)
  printf("%s %s.txt%c", substr($1,1,index($1,",")), f1, ORS)
  for(i=2; i<=NF; i++)
     print $i
}

Thank you, vgersh99.

This is way beyond my ability, a biologist. But your code didn't generate separated new files, instead it lists all things in one file.

Thanks again,