01-18-2008
help to delete brackets [ ]
hi all,
i want to delete brackets in all the file and to keep the string or data between them ( example Q[xxxx] --> Qxxx) with sed command..
thanks
10 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
From the Apache thread in the Adanced forum:
Thats because your browser interprets anything within angle brackets to be an HTML tag. You need to quote these brackets if you want them to appear correctly. The proper quotes are:
&lt; for <
and
&gt; for >
So, for example, you would have... (1 Reply)
Discussion started by: PxT
1 Replies
2. UNIX for Dummies Questions & Answers
I would like to substitute a phrase which contains square brackets.
change TO
how?
Thanks (2 Replies)
Discussion started by: gilead29
2 Replies
3. Shell Programming and Scripting
:D i am pretty much new to scripting and don't want to pick up bad habits so I am trying to get myself to use brackets in my scripts since I plan on using them alot.. !
in this example of a script I wrote I can not figure out where the brackets go can anyone give me some insight into the use of... (3 Replies)
Discussion started by: moxxx68
3 Replies
4. Shell Programming and Scripting
Hi,
I have a query term like this:
$query="apple NOT banana AND fruits";
$query="a1 NOT prim1 AND a2 NOT a3 OR a5";
I want to apply brackets to the NOT terms and the output should be like this:
$query="apple NOT (banana) AND fruits";
$query="a1 NOT (prim1) AND a2 NOT (a3) OR a5";... (2 Replies)
Discussion started by: vanitham
2 Replies
5. Shell Programming and Scripting
Hi
I am having hard time getting this right and need some help. I Have several log files, and everyone contains the following 3 lines at the end:
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 13.01.2011 - 08:03:28
I need to capture the value... (7 Replies)
Discussion started by: nimo
7 Replies
6. Shell Programming and Scripting
how to delete second part in the expression sshd using gsub function so that output look likes sshd.
Thanks. (4 Replies)
Discussion started by: tkmmelvin
4 Replies
7. Shell Programming and Scripting
Hello,
I am trying to write a script using ksh. And I want to get the value within the first brackets of a string. For example:
14/04/11 11:35: 00 This is (nn) from the earth.
Then i hope to get nn in this case.
Can any one advise me how to implement it?
Thank you very much!
nn (2 Replies)
Discussion started by: n_n
2 Replies
8. Shell Programming and Scripting
Hi All,
I have a text file which looks like this:
computer programming
systems engineering
I want to get rid of these square brackets and also the text that is inside these brackets. So that my final text file looks like this:
computer programming
systems engineering
I am using... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
9. Shell Programming and Scripting
Hi all. i need a small help.
i have written an exit code, which will check whether mo.sh is successful or not. if the status is >0 it will exit the shell.
1>Do you guys think it is a correct way to write?
2>what if i change the double bracket to single. how will it change the o/p.
... (1 Reply)
Discussion started by: sub
1 Replies
10. Shell Programming and Scripting
I have the file sed1.txt and I need to strip the brackets (]) and content inside them only when
I have two or three letters followed by a colon.
for example,it may be any letter, not just abc
]
]
#-- cat sed1.txt
1 ] FISICA
2 ]PORTUGUES
3 ] ]MATEMATICA
4 ]]INGLES ]
5 ]QUIMICA
6... (2 Replies)
Discussion started by: dperboni
2 Replies
LEARN ABOUT DEBIAN
iodbctest
iodbctest(1) iODBC Driver Manager iodbctest(1)
NAME
iodbctest, iodbctestw - iODBC Demonstration programs
SYNOPSIS
iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
DESCRIPTION
The iodbctest program and iodbtestw programs are simple ODBC sample programs, showing the strength of the ODBC API to connect to any ODBC
enabled database, issue SQL commands and retrieve the query results.
The iodbctest program uses the standard ODBC API calls to connect using any DSN, but retrieves all results in ASCII mode.
The iodbctestw program uses the ODBC Unicode API calls to connect using any DSN, and retrieves all results in Unicode mode.
OPTIONS
The iodbctest program uses the SQLDriverConnect function to make a connection using any available ODBC compliant driver. This allows the
user to override any ODBC connect attribute in the DSN string.
Connect strings should start with either a DSN=xxx or a DRIVER=xxxx attribute optionally followed by other DSN attributes separated by a
semicolon e.g:
DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u
Any attributes required for a proper connection that are not entered in the DSN connect string, must be present in the odbc.ini file.
If the connect string is passed as an argument to the iodbctest program, the string should be quoted as most shells use the semicolon as
their command separator. If the connect string is entered on the interactive prompt, no quotes should be used.
After a successful connection has been established, the user is prompted for a SQL command to be send to the database. A SQL command cannot
span multiple lines.
If the SQL command returns one or more result sets, each result set is fetched using character buffers and displayed in a table.
Additionally, the iodbctest program understands a few special commands:
qualifiers
Show a list of qualifiers using the SQLTables catalog call.
owners
Show a list of owners using the SQLTables catalog call.
tables
Show a list of tables using the SQLTables catalog call.
types
Show a list of tables types using the SQLTables catalog call.
datatypes
Show a list of data types using the SQLGetTypeInfo catalog call.
reconnect
Perform a disconnect/reconnect with the information saved during the first SQLDriverConnect.
quit (or exit)
Exit the program and return to the shell.
EXAMPLES
Start the iodbctest program and get a list of DSNs before making a connection:
$ iodbctest
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
Enter ODBC connect string (? shows list): ?
DSN | Driver
-----------------------------------------------------------------
ora9 | OpenLink Generic ODBC Driver
mysql | OpenLink Generic ODBC Driver
mysqllite | OpenLink Lite for MySQL
myodbc | MyODBC Driver
pgsql | OpenLink Generic ODBC Driver
tds | OpenLink Generic ODBC Driver
Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger
Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)
SQL>
Connect to an Oracle 9 instance which has been previously setup in the odbc.ini file:
$ iodbctest "DSN=ora9;UID=scott;PWD=tiger"
iODBC Demonstration program
This program shows an interactive SQL processor
Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)
SQL>select * from emp
ID |NAME
-----------------+-------------------------------------------
1 |Record 1
2 |Record 2
2 |Record 3
result set 1 returned 3 rows.
SQL> quit
COPYRIGHT
Copyright (C) 1996-2009 by OpenLink Software
AUTHOR
iODBC Administrator <iodbc@openlinksw.com>
3.52.7 3 August 2005 iodbctest(1)