Rows manupulation using AWK or sed Post: 302478789

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk to convert text files with recurring headings to rows and colum

I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How...

2. Shell Programming and Scripting

Get text between two special rows ?( using awk or sed)?

Hi Friends I am facing some problem in extract the lines between two fixed lines for examplemy text file look like ... -------- line 1 line 2 line 3 --------- line 4 line 5 -------- line 6 line 7 line 8 line 9 line 10 --------- now i want the data between "-------" these...

3. Shell Programming and Scripting

get text between two special rows ?(awk or sed)?

Hello, I've the follwing text: gfdgfg -------------------------------- dfgfdgdfg fdgfdgfdgdgf fdgf ------------------------------ f g gdgf a constant string that i know --------------------------------------------- data I want to have data I want to have data I want to have data I...

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

5. Shell Programming and Scripting

Using sed (or awk or perl) to delete rows in a file

I have a Unix file with 200,000 records, and need to remove all records from the file that have the character �I' in position 68 (68 bytes from the left). I have searched for similar problems and it appears that it would be possible with sed, awk or perl but I do not know enough about any of these...

6. Shell Programming and Scripting

CDR manupulation

Hello Friends, I need to examine a huge CDR file according to a complex (at least for me) condition like below and i couldnt write anything :( In CDR file there are more than hundreds of fields, I need to print the rows which matches the below condition: while $13 field of subsequent...

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

8. Shell Programming and Scripting

awk for string manupulation

Hi All, I have one file with two columns separated by tab. I need to search for second column value of this file in the 5 column of another file. If the match is found replace the 5th column of second file with entire row of the first file. e.g. file1 123 D.abc 234 D.rde 4563 ...

9. Shell Programming and Scripting

Indexing each repeating pattern of rows in a column using awk/sed

Hello All, I have data like this in a column. 0 1 2 3 0 3 4 5 6 0 1 2 3 etc. where 0 identifies the start of a pattern in my data. So I need the output like below using either awk/sed. 0 1

10. Shell Programming and Scripting

awk or sed? rows text to co

Hello Friends! I would like to help the masters ... I have a file with the entry below and would like a script for that output: Input file: 001 1 01-20152142711532-24S 1637909825/05/2015BAHIA SERVICOS R F, ...

LEARN ABOUT DEBIAN

ogamesim

ogamesim(6)							   Games Manual 						       ogamesim(6)

NAME

       Console Ogame Simulator

SYNOPSYS

       ogamesim [ -i <task.txt> ] [ -o <result.txt> ]

DESCRIPTION

       Tasks for simulation are consist of text files.

       Example of task concluding all possible units is adduced bellow.

OPTIONS

       -i <input file>: task file (STDIN unless defined);

       -o <output file>: result file (STDOUT unless defined);

       -s <iterations count>: 1 <= value <= N (no limits);

       -t <max simulation time>: (seconds) 0 <= value <= N, 0=no limits;

       -f <forks count>: 0 <= value <= 100.

RETURN VALUES

       0: if success

EXAMPLES

       Task concluding all possible units:
       attacker
	       attack		       = 9
	       shield		       = 10
	       armory		       = 11

	       Small Cargo	       = 10
	       Large Cargo	       = 10
	       Light Fighter	       = 20
	       Heavy Fighter	       = 30
	       Cruiser		       = 40
	       Battleship	       = 50
	       Colony Ship	       = 60
	       Recycler 	       = 70
	       Espionage Probe	       = 80
	       Bomber		       = 900
	       Destroyer	       = 110
	       Deathstar	       = 120

       defender
	       attack		       = 11
	       shield		       = 12
	       armory		       = 13

	       Rocket Launcher	       = 100
	       Light Laser	       = 200
	       Heavy Laser	       = 300
	       Gauss Cannon	       = 400
	       Ion Cannon	       = 500
	       Plasma Turret	       = 600
	       Small Shield Dome       = 1
	       Large Shield Dome       = 1

	       Solar Satellite	       = 100

	       metal		       = 123456
	       crystal		       = 56789
	       deut		       = 987654

ogamesim							    Dec 4, 2006 						       ogamesim(6)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk to convert text files with recurring headings to rows and colum

Discussion started by: Bjoeboo

2. Shell Programming and Scripting

Get text between two special rows ?( using awk or sed)?

Discussion started by: sushantnirwan

3. Shell Programming and Scripting

get text between two special rows ?(awk or sed)?

Discussion started by: eric_

4. Shell Programming and Scripting

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

Discussion started by: samuelray