10-11-2006
Can this awk statement be modified if the 2 keywords can be preceded by blank spaces before them ?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need help :)
I have two input files and I'd like to generate a report based on the two.
filea:
hostname,account1,password
,account2,password
hostname,account1,password
hostname,account1,password
,account1,password
,account2,password
repeating hostnames are blank
fileb:
hosta... (7 Replies)
Discussion started by: synmag
7 Replies
2. Shell Programming and Scripting
Hi,
I have several block of text that I need to select, however this text may be spread over several lines and contains the '{' and '}' within it.
For e.g.,
ABC=100{
DEF = 200
{
GHI,
JKL
}
}
#2nd Block
123
{
456{78,910}}
}I am trying to figure out how to remove... (2 Replies)
Discussion started by: BootComp
2 Replies
3. Shell Programming and Scripting
Hi,
I have a requirement to select only a specific pattern from a flat file and delete its occurance.
For eg.
If my file contains :
<A1>1234</A1>
<A2>5678</A2>
<ABC>1234</ABC>
<A3>0987</A3>
Then, i want to delete <ABC>1234</ABC> from the file and have the contents as :-... (7 Replies)
Discussion started by: DTechBuddy
7 Replies
4. Shell Programming and Scripting
Hi there, I have a text file with several colums separated by "|;#" I need to search the file extracting all columns starting with the value of "1" or "2" saving in a separate file just the first 7 columns of each row maching the criteria, with replacement of the saparators in the nearly created... (4 Replies)
Discussion started by: capnino
4 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Following is my file output
247 Sleep 25439 NULL
259 Sleep 25460 NULL
277 Sleep 15274 NULL
361 Sleep 2 NULL
362 Sleep 202 NULL
I want to select only first column to other file
How can... (2 Replies)
Discussion started by: kaushik02018
2 Replies
6. Shell Programming and Scripting
Hi
I want to select older file if multiple files exist with same name.
eg:There are five files in UNIX folder
Sample1_20091231
Sample1_20100110
Sample1_20100115
Sample2_20100115
Sample3_20100115
However in file list i.e FileName.DAT I have data like
Sample1
Sample2
Sample3
I am... (5 Replies)
Discussion started by: dashing201
5 Replies
7. Shell Programming and Scripting
Hello:
I am new to shell script programming. Now I would like to select specific records block from a file. For example, current file "xyz.txt" is containing 1million records and want to select the block of records from line number 50000 to 100000 and save into a file. Can anyone suggest me how... (3 Replies)
Discussion started by: nvkuriseti
3 Replies
8. Shell Programming and Scripting
Hi ,
I want to select data from a file .the datas in a file will be in both upper and lower case. can able to select particular data using awk.
file is like
Ram Selva 24332 UNIXTEAM
Karthi Siva 43322 UNIXTEAM
In read if i enter selva as lowercase its not displaying result. (9 Replies)
Discussion started by: boopal
9 Replies
9. Shell Programming and Scripting
Hello,
I use UBUNTU 12.04.
I want to write a short program using awk to select some lines in a file based on a second file.
My first file has this format with about 400,000 lines and 47 fields:
SNP1 1 12.1
SNP2 1 13.2
SNP3 1 45.2
SNP4 1 23.4
My second file has this format:
SNP2
SNP3... (1 Reply)
Discussion started by: Homa
1 Replies
10. Shell Programming and Scripting
i have a file tabel.out which contain table name in this format.
xyz
abc
qwe
Plz help me writing one script which actually takes tablename from file table.out file one by one and then select count (*) from $tablename limit 10; and print error in output file if any tabel is not... (4 Replies)
Discussion started by: netdbaind
4 Replies
LEARN ABOUT OPENDARWIN
start_transaction
START
TRANSACTION(7) SQL Commands START TRANSACTION(7)
NAME
START TRANSACTION - start a transaction block
SYNOPSIS
START TRANSACTION [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
This command begins a new transaction block. If the isolation level or read/write mode is specified, the new transaction has those charac-
teristics, as if SET TRANSACTION [set_transaction(7)] was executed. This is the same as the BEGIN [begin(7)] command.
PARAMETERS
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the parameters to this statement.
COMPATIBILITY
In the standard, it is not necessary to issue START TRANSACTION to start a transaction block: any SQL command implicitly begins a block.
PostgreSQL's behavior can be seen as implicitly issuing a COMMIT after each command that does not follow START TRANSACTION (or BEGIN), and
it is therefore often called ``autocommit''. Other relational database systems might offer an autocommit feature as a convenience.
The SQL standard requires commas between successive transaction_modes, but for historical reasons PostgreSQL allows the commas to be omit-
ted.
See also the compatibility section of SET TRANSACTION [set_transaction(7)].
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], SAVEPOINT [savepoint(7)], SET TRANSACTION [set_transaction(7)]
SQL - Language Statements 2010-05-14 START TRANSACTION(7)