06-26-2008
sed help needed badly
how can I delete one line above and below the matching pattern ?
e.g I want to delete the line above and below the line with %CLI- in example below :
$CHECKSUM $1$DGA1043:[ORACLE.PATRON]TSTST01.DBF;1
%CLI-E-OPENIN, error opening $1$DGA1043:[ORACLE]TSTST01.DBF
-RMS-E-FLK, file currently locked by another user
thanks .
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I need to insert a line into a file underneath an existing line in the file, but am unsure as to the syntax. I'm pretty sure sed can be used though, although any ideas are more than welcome. For example:
File
----
Line 1
Line 2
Line 3
Line 4
Line 6
I need to say: Insert "Line 5"... (1 Reply)
Discussion started by: danhodges99
1 Replies
2. Shell Programming and Scripting
Could someone tell me how to replace varibles using SED inside Korn Shell?
e.g. I have a ksh file program.ksh below:
------------------------------------
#!/bin/ksh
sed -n '/ABC/p' $1 > output.txt
if ]
then
status=new
elif ]
then
status=old
fi
sed -n '/$status/p' $1... (5 Replies)
Discussion started by: stevefox
5 Replies
3. Shell Programming and Scripting
Hi All,
i have one file and in that i have to read each line and do some replacement.
its is not fixed the number or column always be same it can be less also
exm
a;b;c;d;e;f (line)
i have to do something like
In the line
If c is present
then
go to end of line and append ';date'
else... (9 Replies)
Discussion started by: ravi.sadani19
9 Replies
4. Shell Programming and Scripting
Hi,
I have a file in a form of
jkkhjjk1:!:jkhdjkhjkh2:!:kljkljkljklj3:!:kljsdj4
kljlkfljf5:!:kjljljlj6:!:jhjkhjkh7
I am trying to use sed command such that everytime it find ":!:" it will removes it and print remaining of the line on the new line
Output that I need will look like following... (8 Replies)
Discussion started by: arushunter
8 Replies
5. Shell Programming and Scripting
Hi,
I have the following texts :
#1#http://www.google.com#2#Google#3#
#1#http://www.aol.com#2#AOL#3#
I need a bash script which extracts the text between the markers (marks are #1#,#2#,#3#).
I also need that text in variables ($URL and $DESCRIPT will be fine) so I can later use it to... (3 Replies)
Discussion started by: tcp27br
3 Replies
6. UNIX for Dummies Questions & Answers
I am trying to retrieve part of a line from /boot/grub/menu.lst
The line is :
gfxmenu (hd0,0)/usr/share/gfxboot/themes/pclinuxblue/boot/message
I have figured out how to get this line into a file by itself.
sed '/gfxmenu/ !d' /boot/grub/menu.lst > /tmp/menu.lst.pcl_tc
What I need to... (2 Replies)
Discussion started by: Tide
2 Replies
7. Shell Programming and Scripting
i'm trying to run the following program but i keep getting the message "badly placed ()'s" can u help?
#include "modularity_mat.h"
#include "../sparse_mlpl/sparse_matrix.h"
adj_matrix_arr* allocate_mem_for_matrix_arr (int y) {
/* Create the adj matrix and allocate memory */
... (2 Replies)
Discussion started by: ronirosner
2 Replies
8. Shell Programming and Scripting
I have file with following contents;
127.0.0.1 www.google.com
127.3.3.1 www.cisco.com
127.3.5.1 www.msnbc.com
I want output as
127.0.0.1 www.google.com google.com
127.3.3.1 www.cisco.com cisco.com
127.3.5.1 www.msnbc.com msnbc.com
I tried
sed 's/www.//g'... (5 Replies)
Discussion started by: sangfroid
5 Replies
9. Shell Programming and Scripting
I want to search texts between first occurence of the matching pattern and replace it with some other text.pls advice what can be done. I searched alot, i could not find anything relevant.
Ex my input is as follows:
red
yellow
grey
white
blue
red
pink
violet
white
I want to search... (9 Replies)
Discussion started by: sangitajc
9 Replies
10. Shell Programming and Scripting
Edit - I don't know how to delete posts. The question I asked here ended up not being the question I should have asked as I didn't realise I needed to edit my script to comply with SGE.
Hi,
My script is:
#!/bin/bash
# Perform fastqc on files in a specified directory.
for ((j=1;... (8 Replies)
Discussion started by: una1992
8 Replies
LEARN ABOUT DEBIAN
databaseintro
databaseintro(1grass) Grass User's Manual databaseintro(1grass)
Database management in GRASS GIS
Attribute management in general
GRASS can be linked to one or many database management systems (DBMS). The db.* set of commands provides basic SQL support for attribute
management, while the v.db.* set of commands operates on the vector map (see Vector introduction).
Available drivers
Available drivers are listed in SQL support in GRASS GIS.
Notes:
The default DBF driver provides only very limited SQL support (as DBF is not an SQL DB) while the other DBMS backends (such as PostgreSQL,
MySQL etc) provide full SQL support since the SQL commands are sent directly to the DBMS.
DB connection management
The current database management settings are shown or modified with db.connect for current mapset. Available DBMI drivers are listed with
db.drivers. Some DBMI backends require a user/password for driver/database to be set with db.login. In order to test a driver, run
db.test.
Attribute data import and export
Attribute data can be imported with db.in.ogr from various formats and exported with db.out.ogr. To internally copy a a full table or
selectively parts of it, use db.copy.
Further conversion tools:
MDB Tools: Convert MS-Access data to SQL, DBF, etc.
Openoffice.org with SQL Databases
SQL commands
GRASS supports to main SQL operations, execution of an SQL statement (db.execute) and selection of data from a table (db.select). See the
SQL help page for examples.
Managing the default DBMI settings
Per default vector map attributes are stored in DBF table files. This default definition can be modified with db.connect. If an external
DBMS is used, db.login may be required.
Creating a database
Specific commands are explained on the individual driver pages (these pages are only available if driver was compiled in this installa-
tion):
DBF: see DBF page
SQLite: SQLite page
mySQL: meSQL pages
ODBC: ODBC page (connect to Oracle, etc.)
PostgreSQL: PostgreSQL and PostGIS page
Metadata
All columns for a given table are listed with db.columns. The command db.describe describes a table in detail. To list all available
tables for a given database, run db.tables.
Table maintenance
To drop a column from a selected attribute table, use db.dropcol. With db.droptable an attribute table can be deleted.
Database Schema
Currently schema support only works for PostgreSQL connections. Default schema can be set with db.connect. Note that the default schema
will be used by all db.* modules.
db.tables returns 'schema.table' if schemas are available in the database.
Migrating to a different database engine
To migrate a GRASS database table (or a GRASS vector map) to a different DBMI engine, the best solution is to create a new MAPSET, define
the DBMI settings accordingly with db.login. Then the table of interest can be copied over with db.copy from the original MAPSET. Like-
wise, a vector map including its table(s) are copied from the original MAPSET to the current MAPSET with g.copy.
See also
Introduction to GRASS vector map processing
Introduction to GRASS raster map processing
Main index - database index - full index
(C) 2008-2011 GRASS Development Team
GRASS 6.4.2 databaseintro(1grass)