awk/sed column replace using column header

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...

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 ...

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 ...

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....

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...

6. UNIX for Dummies Questions & Answers

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

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...

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...

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. 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 ...

LEARN ABOUT HPUX

split

split(1)						      General Commands Manual							  split(1)

NAME

       split - split a file into pieces

SYNOPSIS

       line_count] suffix_length] [file [name]]

       nsuffix_length] [file [name]]

   Obsolescent
       n] [file [name]]

DESCRIPTION

       reads  file  and  writes  it  in  pieces  (default  1000 lines) onto a set of output files.  The name of the first output file is name with
       appended, and so on lexicographically, up to (only ASCII letters are used, a maximum of 676 files).  If no output name  is  given,  is  the
       default.

       If no input file is given, or if is given instead, the standard input file is used.

   Options
       recognizes the following command-line options and arguments:

	      The input file is split into pieces
			     line_count lines in size.

	      suffix_length  letters  are  used  to  form the suffix of the output filenames.  This option allows creation of more than 676 output
			     files.  The output file names created cannot exceed the maximum file name length allowed in the directory	containing
			     the files.

	      The input file is split into pieces
			     n bytes in size.

	      The input file is split into pieces
			     n x 1024 bytes in size.  No space separates the n from the

	      The input file is split into pieces
			     n x 1048576 bytes in size.  No space separates the n from the

	      The input file is split into pieces
			     n lines in size.  This option is obsolescent and is equivalent to using the option.

EXTERNAL INFLUENCES

   Environment Variables
       determines the locale for the interpretation of text as single- and/or multi-byte characters.

       determines the language in which messages are displayed.

       If  or  is  not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty
       variable.  If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of

       If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are  set  to	"C".   See
       environ(5).

   International Code Set Support
       Single- and multi-byte character code sets are supported.

SEE ALSO

       csplit(1).

STANDARDS CONFORMANCE

																	  split(1)