Sponsored Content
Top Forums Shell Programming and Scripting awk/sed column replace using column header - help Post 302206307 by danmero on Tuesday 17th of June 2008 12:38:08 PM
Old 06-17-2008
Basic shift:
Code:
 awk '{print $1,$2,$3,$6,$5,$7}' log.txt

The output is:
Code:
0000000    N   a   m   e       A   g   e       S   e   x       a   l   i
0000020    a   s       n   f   l   d       x   s   d  \n   C   C       2
0000040    5       M       K   K       a   s   x       Y  \n   B   B
0000060    2   1       F       S   S       a   w   e       N  \n   S   D
0000100        2   1       M       S   D       r   t   y       A  \n
0000117

Your output is:
Code:
0000000    N   a   m   e       A   g   e       S   e   x       a   l   i
0000020    a   s       n   f   l   d           x   s   d  \n   C   C
0000040    2   5       M       K   K       a   s   x           Y  \n   B
0000060    B       2   1       F       S   S       a   w   e           N
0000100   \n   S   D       2   1       M       S   D       r   t   y
0000120        A  \n
0000123

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find and replace a column that has '' to NULL in a comma delimited using awk or sed

Hi this is my first time posting ever. I'm relatively new in using AWK/SED, I've been trying many a solution. I'm trying to replace the 59th column in a file where if I encounter '' then I would like to replace it with the word NULL. example 0 , '' , '' , 0 , 195.538462 change it to 0... (5 Replies)
Discussion started by: gumal901
5 Replies

2. Shell Programming and Scripting

Awk or Sed, fubd match in column, then edit column.

FILE A: 9780743551526,(Abridged) 9780743551779,(Unabridged) 9780743582469,(Abridged) 9780743582483,(Unabridged) 9780743563468,(Abridged) 9780743563475,(Unabridged) FILE B: c3saCandyland 9780743518321 "CANDYLAND" "MCBAIN, ED" 2001 c3sbCandyland 9780743518321 ... (7 Replies)
Discussion started by: glev2005
7 Replies

3. Shell Programming and Scripting

Replace last row of a column in bash/awk/sed

Hi, I've got a file with 3 columns which ends like this: ... 1234 345 1400 5287 733 1400 8472 874 1400 9317 726 1400 I want to replace the last row of the last column with the value 0. So my new file will end: ... 1234 345 1400 5287 733 1400 8472 874 1400 9317 726 ... (5 Replies)
Discussion started by: jhunter87
5 Replies

4. Shell Programming and Scripting

awk/sed to search & replace data in first column

Hi All, I need help in manipulating the data in first column in a file. The sample data looks like below, Mon Jul 18 00:32:52 EDT 2011,NULL,UAT Jul 19 2011,NULL,UAT 1] All field in the file are separated by "," 2] File is having weekly data extracted from database 3] For eg.... (8 Replies)
Discussion started by: gr8_usk
8 Replies

5. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

6. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

7. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies

8. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

9. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy... (10 Replies)
Discussion started by: Kunalcurious
10 Replies

10. UNIX for Beginners Questions & Answers

Awk/sed summation of one column based on some entry in first column

Hi All , I am having an input file as stated below Input file 6 ddk/djhdj/djhdj/Q 10 0.5 dhd/jdjd.djd.nd/QB 01 0.5 hdhd/jd/jd/jdj/Q 10 0.5 512 hd/hdh/gdh/Q 01 0.5 jdjd/jd/ud/j/QB 10 0.5 HD/jsj/djd/Q 01 0.5 71 hdh/jjd/dj/jd/Q 10 0.5 ... (5 Replies)
Discussion started by: kshitij
5 Replies
term(4) 							   File Formats 							   term(4)

NAME
term - format of compiled term file SYNOPSIS
/usr/share/lib/terminfo/?/* DESCRIPTION
The term file is compiled from terminfo(4) source files using tic(1M). Compiled files are organized in a directory hierarchy under the first letter of each terminal name. For example, the vt100 file would have the pathname /usr/lib/terminfo/v/vt100. The default directory is /usr/share/lib/terminfo. Synonyms for the same terminal are implemented by multiple links to the same compiled file. The format has been chosen so that it is the same on all hardware. An 8-bit byte is assumed, but no assumptions about byte ordering or sign extension are made. Thus, these binary terminfo files can be transported to other hardware with 8-bit bytes. Short integers are stored in two 8-bit bytes. The first byte contains the least significant 8 bits of the value, and the second byte con- tains the most significant 8 bits. (Thus, the value represented is 256*second+first.) The value -1 is represented by 0377,0377, and the value -2 is represented by 0376,0377; other negative values are illegal. The -1 generally means that a capability is missing from this ter- minal. The -2 means that the capability has been cancelled in the terminfo source and also is to be considered missing. The compiled file is created from the source file descriptions of the terminals (see the -I option of infocmp) by using the terminfo com- piler, tic, and read by the routine setupterm (see curses(3CURSES)). The file is divided into six parts in the following order: the header, terminal names, boolean flags, numbers, strings, and string table. The header section begins the file six short integers in the format described below. These integers are: 1. the magic number (octal 0432); 2. the size, in bytes, of the names section; 3. the number of bytes in the boolean section 4. the number of short integers in the numbers section; 5. the number of offsets (short integers) in the strings section; 6. the size, in bytes, of the string table. The terminal name section comes next. It contains the first line of the terminfo description, listing the various names for the terminal, separated by the bar ( | ) character (see term(5)). The section is terminated with an ASCII NUL character. The terminal name section is followed by the Boolean section, number section, string section, and string table. The boolean flags section consists of one byte for each flag. This byte is either 0 or 1 as the flag is present or absent. The value of 2 means that the flag has been cancelled. The capabilities are in the same order as the file <term.h>. Between the boolean flags section and the number section, a null byte is inserted, if necessary, to ensure that the number section begins on an even byte offset. All short integers are aligned on a short word boundary. The numbers section is similar to the boolean flags section. Each capability takes up two bytes, and is stored as a short integer. If the value represented is -1 or -2, the capability is taken to be missing. The strings section is also similar. Each capability is stored as a short integer, in the format above. A value of -1 or -2 means the capa- bility is missing. Otherwise, the value is taken as an offset from the beginning of the string table. Special characters in ^X or c nota- tion are stored in their interpreted form, not the printing representation. Padding information ($<nn>) and parameter information (%x) are stored intact in uninterpreted form. The final section is the string table. It contains all the values of string capabilities referenced in the string section. Each string is null terminated. Note that it is possible for setupterm to expect a different set of capabilities than are actually present in the file. Either the database may have been updated since setupterm has been recompiled (resulting in extra unrecognized entries in the file) or the program may have been recompiled more recently than the database was updated (resulting in missing entries). The routine setupterm must be prepared for both possibilities--this is why the numbers and sizes are included. Also, new capabilities must always be added at the end of the lists of boolean, number, and string capabilities. As an example, here is terminal information on the AT&T Model 37 KSR terminal as output by the infocmp -I tty37 command: 37|tty37|AT&T model 37 teletype, hc, os, xon, bel=^G, cr= , cub1=, cud1= , cuu1=E7, hd=E9, hu=E8, ind= , The following is an octal dump of the corresponding term file, produced by the od -c /usr/share/lib/terminfo/t/tty37 command: 0000000 032 001 032 013 021 001 3 3 7 | t 0000020 t y 3 7 | A T & T m o d e l 0000040 3 7 t e l e t y p e 0000060 001 001 0000100 001 377 377 377 377 377 377 377 377 377 377 0000120 377 377 377 377 377 377 377 377 377 377 377 377 377 377 & 0000140 377 377 377 377 377 377 377 377 377 377 377 377 377 377 0000160 377 377 " 377 377 377 377 ( 377 377 377 377 377 377 0000200 377 377 0 377 377 377 377 377 377 377 377 - 377 377 0000220 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377 * 0000520 377 377 377 377 377 377 377 377 377 377 377 377 377 377 $ 0000540 377 377 377 377 377 377 377 377 377 377 377 377 377 377 * 0000560 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377 377 * 0001160 377 377 377 377 377 377 377 377 377 377 377 377 377 377 3 7 0001200 | t t y 3 7 | A T & T m o d e 0001220 l 3 7 t e l e t y p e 0001240 007  033 8 033 9 033 7 0001260 0001261 Some limitations: total compiled entries cannot exceed 4096 bytes; all entries in the name field cannot exceed 128 bytes. FILES
/usr/share/lib/terminfo/?/* compiled terminal description database /usr/include/term.h terminfo header /usr/xpg4/include/term.h X/Open Curses terminfo header SEE ALSO
infocmp(1M), curses(3CURSES), curses(3XCURSES), terminfo(4), term(5) SunOS 5.10 3 Jul 1996 term(4)
All times are GMT -4. The time now is 12:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy