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
DPNS_STAT(3)						      DPNS Library Functions						      DPNS_STAT(3)

NAME
dpns_stat - get information about a DPNS file or directory in the name server SYNOPSIS
#include <sys/types.h> #include "dpns_api.h" int dpns_lstat (const char *path, struct dpns_filestat *statbuf) int dpns_stat (const char *path, struct dpns_filestat *statbuf) int dpns_statx (const char *path, struct dpns_fileid *file_uniqueid, struct dpns_filestat *statbuf) DESCRIPTION
dpns_stat gets information about a DPNS file or directory in the name server. dpns_lstat is identical to dpns_stat except for symbolic links. dpns_lstat retrieves information about the link itself, while dpns_stat gets information about the file/directory referenced by the symbolic link. dpns_statx returns the same information plus the file unique id (name server hostname and file id). The file can be specified by path name or by file_uniqueid. If both are given, file_uniqueid is used. path specifies the logical pathname relative to the current DPNS directory or the full DPNS pathname. The structure pointed to by statbuf contains the following members: u_signed64 fileid; /* entry unique identifier */ mode_t filemode; /* see below */ int nlink; /* number of files in a directory */ uid_t uid; gid_t gid; u_signed64 filesize; time_t atime; /* last access to file */ time_t mtime; /* last file modification */ time_t ctime; /* last metadata modification */ short fileclass; /* 1--> experiment, 2 --> user */ char status; /* '-' --> online, 'm' --> migrated */ filemode is constructed by OR'ing the bits defined in <sys/stat.h> under Unix or "statbits.h" under Windows/NT: S_IFLNK 0xA000 symbolic link S_IFREG 0x8000 regular file S_IFDIR 0x4000 directory S_ISUID 0004000 set user ID on execution S_ISGID 0002000 set group ID on execution S_ISVTX 0001000 sticky bit S_IRUSR 0000400 read by owner S_IWUSR 0000200 write by owner S_IXUSR 0000100 execute/search by owner S_IRGRP 0000040 read by group S_IWGRP 0000020 write by group S_IXGRP 0000010 execute/search by group S_IROTH 0000004 read by others S_IWOTH 0000002 write by others S_IXOTH 0000001 execute/search by others RETURN VALUE
This routine returns 0 if the operation was successful or -1 if the operation failed. In the latter case, serrno is set appropriately. ERRORS
ENOENT The named file/directory does not exist or is a null pathname. EACCES Search permission is denied on a component of the path prefix. EFAULT path or statbuf is a NULL pointer. ENOTDIR A component of path prefix is not a directory. ENAMETOOLONG The length of path exceeds CA_MAXPATHLEN or the length of a path component exceeds CA_MAXNAMELEN. SENOSHOST Host unknown. SENOSSERV Service unknown. SECOMERR Communication error. ENSNACT Name server is not running or is being shutdown. SEE ALSO
Castor_limits(4), dpns_chdir(3), dpns_chmod(3), dpns_chown(3), dpns_creat(3) AUTHOR
LCG Grid Deployment Team DPNS
$Date: 2003/09/02 07:08:38 $ DPNS_STAT(3)
All times are GMT -4. The time now is 01:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy