Add row, awk, sed ? Post: 302268737

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with sed to add delimiter and new field to each row

I have a file with millions of rows that I need to add a delimiter and a new field with a zero to the end of each row. (its too big to open and do a find and replace regex) I'm looking for the next line '\n' and need to replace it with a Unit Separator (hex \037) 0 \n. I've tried the...

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which...

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 get unique row

Hello ALL, I have very huge file almost 25G size contents of the file are "|" delimited columns on each row eg: 1396745|1078529|KDS|2011-04-21 00:00:00.0|1100|30|2|2011-04-20 22:35:24.0|2011-04-20 22:35:24.0|0|2011-04-21 00:00:00.0|1100|2222434|2011-04-21 11:00:00.0|0|0|2011-06-29...

5. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Hi, I'm using AIX(ksh shell). > cat temp.txt "a","b",0 "c",bc",0 "a1","b1",0 "cc","cb",1 "cc","b2",1 "bb","bc",2 I want the output as: "a","b","c","bc","a1","b1" "cc","cb","cc","b2" "bb","bc" I want to combine multiple lines into single line where third column is same. Is...

6. Shell Programming and Scripting

Awk to add selected row column data

Looks at the most efficient way to add up the column of data based off of the rows. Random data Name-Number-ID Sarah-2.0-15 Bob-6.3-15 Sally-1.0-10 James-1.0-10 Scotty-10.7-15 So I would select all those who have ID = 15 and then add up total number read - p "Enter ID number" Num ...

7. Shell Programming and Scripting

add and subtract specific row using awk

Hi Folks I have tried awk command to conditionally add or subtract value from specific row in a file. The test file looks like: # cat test.txt cont x y Max 0.3 0.9 Min 0.2 0.9 diff 0.1 0 # awk '{for (i=2; i <=NF; i++) if ($i== "0") $i=$i+0.2; print}' test.txt Output: cont...

8. Shell Programming and Scripting

Awk/sed script for transposing any number of rows with header row

Greetings! I have been trying to find out a way to take a CSV file with a large number of rows, and a very large number of columns (in the thousands) and convert the rows to a single column of data, where the first row is a header representing the attribute name and the subsequent series of...

9. Shell Programming and Scripting

Reading and appending a row from file1 to file2 using awk or sed

Hi, I wanted to add each row of file2.txt to entire length of file1.txt given the sample data below and save it as new file. Any idea how to efficiently do it. Thank you for any help. input file file1.txt file2.txt 140 30 200006 141 32 140 32 200006 142 33 140 35 200006 142...

10. Shell Programming and Scripting

awk to skip header row and add string to field

The awk below does put in VUS in the 9th field but I can not seem to skip the header then add the VUS. I tried to incorporate NR >=2 and NR > 1 with no luck. Thank you :). input Chr Start End Ref Alt Func.refGene PopFreqMax CLINSIG Classification chr1 43395635 ...

LEARN ABOUT ULTRIX

make_sockdfc

MAKE_SOCKDFC(8) 					      System Manager's Manual						   MAKE_SOCKDFC(8)

NAME

       make_sockdfc -  Generates frozen configuratyion file for SOCKS server

SYNOPSIS

       make_sockdfc [infile [outfile] ]

DESCRIPTION

       make_sockdfc reads in a plain-text configuration file for the SOCKS server and produces a frozen configuration file as the output.

       Both  arguments	are  optional. The default for infile is /etc/sockd.conf; the default for outfile is /etc/sockd.fc. You may specify infile
       while omitting outfile, but you cannot specify outfile without also speficying infile.

       The contents of the frozen configuration file is essentially the memory image of the parsed input file. Using the frozen configuration file
       can reduce the start-up delay of the SOCKS server program since it no longer has to parse the file contents.

       When  the  SOCKS  server  starts, it always looks for the frozen configuration file /etc/sockd.fc first. If that file is not found, it then
       tries to use the plain-text configuration file /etc/sockd.conf. If you use frozen configuration, you  must  remember  to  run  make_sockdfc
       every time after you modify the plain-text file or the SOCKS server will continue to use the frozen file of a previous configuration.

       To find out the contents of a frozen configuration file, use dump_sockdfc.

FILES

       /etc/sockd.fc, /etc/sockd.conf

SEE ALSO

       dump_sockdfc(8), sockd.conf(5), sockd.fc(5)

AUTHOR

       Ying-Da Lee, yingda@best.com or yingda@esd.sgi.com

								    May 6, 1996 						   MAKE_SOCKDFC(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with sed to add delimiter and new field to each row

Discussion started by: kmac

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Discussion started by: ks_reddy

3. Shell Programming and Scripting

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

Discussion started by: jhunter87

4. Shell Programming and Scripting

awk/sed to get unique row

Discussion started by: posner