Get value of last row and 6 column from awk Post: 302212891

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk question row into column

I have a csv file: test1.csv with 26 columns Sample: Data collected Comp1,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non Zero,0,0,0,0,0,0,0,0,0,...,0 %Utilization,0.1,0.23,0.14,...,0.36 Data collected Comp2,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non...

2. Shell Programming and Scripting

awk-gsub on column-wise on each row

awk '{ gsub(/....=/,""); print }' want.dat >final.dat the above awk command which removes all the chars before and including '=' on the entire row. --thats what it meant be.:) but i need to remove text on column-wise on each row. many thanks, EM ---------- Post updated at 10:00 AM...

3. Shell Programming and Scripting

awk: Transpose csv row to column.

Hello, am I new to awk, and I am tryint to: INPUT FILE: "73423555","73423556","73423557","73423558","73423559" OUTPUT FILE: 73423555 73423556 73423557 73423558 73423559 My useless code so far: #!/bin/awk -F ',' BEGIN { i=0; }

4. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Hi all! I have this kind of output: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row. In order to obtain: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2...

5. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid

6. Shell Programming and Scripting

awk transpose row into 2 field column

Need to transpose every 2 fields of a row into a single 2 field column. input 4 135 114 76 217 30 346 110 5 185 115 45 218 85 347 125 6 85 116 130 220 65 352 95 11 30 117 55 221 42 355 75 16 72 118 55 224 37 357 430 17 30 119 55 225 40 358 62 21 52 120 65 232 480 360 180 .......

7. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

8. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second...

9. Shell Programming and Scripting

awk script row to column

Hi.. I have data : Report testing1 20180419 08:00 Report testing2 20180419 07:35 Report testing 20180419 08:01 Source = data1 Report testing4 20180419 08:05 Source = data1 Report testing5 20180419 08:10 Source = data2 Report testing6 20180419 08:01 Report testing7 20180419 08:19...

10. UNIX for Beginners Questions & Answers

Script to do column to row in awk

Hi , Can anyone help me suggesting - how to do the below trick with awk Input 120 130 140 210 310 410 645 729 800 Output 120 130 140

LEARN ABOUT SUNOS

largefile

largefile(5)						Standards, Environments, and Macros					      largefile(5)

NAME

       largefile - large file status of utilities

DESCRIPTION

       A  large file is a regular file whose size is greater than or equal to 2 Gbyte ( 2**31 bytes). A small file is a regular file whose size is
       less than 2 Gbyte.

   Large file aware utilities
       A utility is called large file aware if it can process large files in the same manner as it does small files. A utility that is large  file
       aware is able to handle large files as input and generate as output large files that are being processed. The exception is where additional
       files  are used as system configuration files or support files that can augment the processing. For example, the file utility supports  the
       -m  option  for	an  alternative "magic" file and the -f option for a support file that can contain a list of file names. It is unspecified
       whether a utility that is large file aware will accept configuration or support files that are large files. If a large file  aware  utility
       does  not accept configuration or support files that are large files, it will cause no data loss or corruption upon encountering such files
       and will return an appropriate error.

       The following /usr/bin utilities are large file aware:

       adb	     awk	   bdiff	 cat	       chgrp
       chmod	     chown	   cksum	 cmp	       compress
       cp	     csh	   csplit	 cut	       dd
       dircmp	     du 	   egrep	 fgrep	       file
       find	     ftp	   getconf	 grep	       gzip
       head	     join	   jsh		 ksh	       ln
       ls	     mdb	   mkdir	 mkfifo        more
       mv	     nawk	   page 	 paste	       pathchck
       pg	     rcp	   remsh	 rksh	       rm
       rmdir	     rsh	   sed		 sh	       sort
       split	     sum	   tail 	 tar	       tee
       test	     touch	   tr		 uncompress    uudecode
       uuencode      wc 	   zcat

       The following /usr/xpg4/bin utilities are large file aware:

       awk	     cp 	   chgrp	 chown	       du
       egrep	     fgrep	   file 	 grep	       ln
       ls	     more	   mv		 rm	       sed
       sh	     sort	   tail 	 tr

       The following /usr/xpg6/bin utilities are large file aware:

       getconf	     ls 	   tr

       The following /usr/sbin utilities are large file aware:

       install	     mkfile	   mknod	 mvdir	       swap

       See the USAGE section of the swap(1M) manual page for limitations of swap on block devices greater than 2 Gbyte on a 32-bit operating  sys-
       tem.

       The following /usr/ucb utilities are large file aware:

       chown	     from	   ln		 ls	       sed
       sum	     touch

       The /usr/bin/cpio and /usr/bin/pax utilities are large file aware, but cannot archive a file whose size exceeds 8 Gbyte - 1 byte.

       The /usr/bin/truss utilities has been modified to read a dump file and display information relevant to large files, such as offsets.

   cachefs file systems
       The following /usr/bin utilities are large file aware for cachefs file systems:

       cachefspack	cachefsstat

       The following /usr/sbin utilities are large file aware for cachefs file systems:

       cachefslog	cachefswssize	cfsadmin	 fsck
       mount		umount

   nfs file systems
       The following utilities are large file aware for nfs file systems:

       /usr/lib/autofs/automountd    /usr/sbin/mount
       /usr/lib/nfs/rquotad

   ufs file systems
       The following /usr/bin utility is large file aware for ufs file systems:

	      df

       The following /usr/lib/nfs utility is large file aware for ufs file systems:

	      rquotad

       The following /usr/xpg4/bin utility is large file aware for ufs file systems:

	      df

       The following /usr/sbin utilities are large file aware for ufs file systems:

       clri	     dcopy	   edquota	 ff	       fsck
       fsdb	     fsirand	   fstyp	 labelit       lockfs
       mkfs	     mount	   ncheck	 newfs	       quot
       quota	     quotacheck    quotaoff	 quotaon       repquota
       tunefs	     ufsdump	   ufsrestore	 umount

   Large file safe utilities
       A  utility  is called large file safe if it causes no data loss or corruption when it encounters a large file. A utility that is large file
       safe is unable to process properly a large file, but returns an appropriate error.

       The following /usr/bin utilities are large file safe:

       audioconvert	audioplay    audiorecord    comm	  diff
       diff3		diffmk	     ed 	    lp		  mail

       mailcompat	mailstats    mailx	    pack	  pcat
       red		rmail	     sdiff	    unpack	  vi
       view

       The following /usr/xpg4/bin utilities are large file safe:

       ed	     vi 	   view

       The following /usr/xpg6/bin utility is large file safe:

       ed

       The following /usr/sbin utilities are large file safe:

       lpfilter      lpforms

       The following /usr/ucb utilities are large file safe:

       Mail	     lpr

       The following /usr/lib utility is large file safe:

	      sendmail

SEE ALSO

       lf64(5), lfcompile(5), lfcompile64(5)

SunOS 5.10							    7 Nov 2003							      largefile(5)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk question row into column

Discussion started by: calitiggr

2. Shell Programming and Scripting

awk-gsub on column-wise on each row

Discussion started by: elamurugu

3. Shell Programming and Scripting

awk: Transpose csv row to column.

Discussion started by: drbiloukos

4. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Discussion started by: lucasvs