Shell Programming and Scripting

Hi,

I have a file with below contents.

Code:

Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4

The file has only 2 rows and is tab separated
The desired output is :

Code:

Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4

CAn you please help?

Use gawk, nawk or /usr/xpg4/bin/awk on Solaris:

Code:

awk 'END { 
  while (++j < i) 
    print _[j] 
    }
{
  for (i = 0; ++i <= NF;)
    _[i] = _[i] ? _[i] FS $i : $i
  }' infile

Thanks for your reply, however i am unable to run the script, which shell are you using.
Below r the details of my env.


Machine hardware: sun4us
OS version: 5.10
Processor type: sparc
Hardware: FJSV,GPUZC-M

The following components are installed on your system:


Sun Studio 11
Sun Studio 11 C Compiler
Sun Studio 11 C++ Compiler
Sun Studio 11 Tools.h++ 7.1
Sun Studio 11 C++ Standard 64-bit Class Library
Sun Studio 11 Garbage Collector
Sun Studio 11 Fortran 95
Sun Studio 11 Debugging Tools (including dbx)
Sun Studio 11 IDE
Sun Studio 11 Debugger GUI
Sun Studio 11 Performance Analyzer (including collect, ...)
Sun Studio 11 X-Designer
Sun Studio 11 VIM editor
Sun Studio 11 XEmacs editor
Sun Studio 11 Native Connector Tool
Sun Studio 11 Performance Library
Sun Studio 11 LockLint
Sun Studio 11 Building Software (including dmake)
Sun Studio 11 Documentation Set

version of "/opt/SUNWspro/bin/../prod/bin/../../bin/cc": Sun C 5.8 2005/10/13
version of "/opt/SUNWspro/bin/../prod/bin/../../bin/CC": Sun C++ 5.8 2005/10/13
version of "/opt/SUNWspro/bin/../prod/bin/../../bin/f90": Sun Fortran 95 8.2 2005/10/13
version of "/opt/SUNWspro/bin/../prod/bin/../../bin/dbx": Sun Dbx Debugger 7.5 2005/10/13
version of "/opt/SUNWspro/bin/../prod/bin/../../bin/analyzer": Sun Performance Analyzer 7.5 2005/10/13
version of "/opt/SUNWspro/bin/../prod/bin/../../bin/dmake": Sun Distributed Make 7.7 2005/10/13

What happens? Do you get errors or an incorrect output?
If you're using (t)csh, you should run the command as a script.

script content:

Code:

END {     
  while (++j < i) 
    print _[j] 
    }
{
  for (i = 0; ++i <= NF;)
    _[i] = _[i] ? _[i] OFS $i : $i
  }

To execute:

Code:

nawk -f <script_name> OFS='\t' <input_file_name>

P.S. Added OFS as per OP requirement.

Code:

#head -1 infile | tr " " "\n"  > tmp
#tail -1  infile | tr " " "\n"  > tmp1

Code:

#paste tmp tmp1
Heading1        Value1
Heading2        Value2
Heading3        Value3
Heading4        Value4

Thanks,
Penchal

Thanks a lot both of you !