08-10-2010
hi,
i have given only one column value in the data provided...and moreover i need to find and replace whereever that 404-064-xxxx-xxx-xxxx (any length upto space) has to be removed...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm trying to figure out how to build a small shell script that will find old .shtml files in every /tgp/ directory on the server and delete them if they are older than 10 days...
The structure of the paths are like this:
/home/domains/www.domain2.com/tgp/
/home/domains/www.domain3.com/tgp/... (1 Reply)
Discussion started by: Neko
1 Replies
2. Programming
hi
I wanted to find this char " ^M " in my file and replace it with blank space.
I am using Unix system.
If i give command " :%s/^M//gc " it wont work
so can anyone tell what is command to find and replace
thankx (3 Replies)
Discussion started by: mridula
3 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
My problem is the following:
I've a script that must list all files in a directory and write this information in a text file.
I've tried to get the list through ls command and then write it using msgecho
msgecho "`ls $PATH_APS_JOB_ORA`"
This works good but the created string... (7 Replies)
Discussion started by: callimaco0082
7 Replies
4. Shell Programming and Scripting
Hi,
I have a file named "Test_2008_01_21"
The file contains a string "manual" that occurs many times in the file
How can i find the positions of the string "manual" in the file
Ex: if the string " manual " occurs three times in the file. i want to replace the second occurance of string... (6 Replies)
Discussion started by: bab123
6 Replies
5. Shell Programming and Scripting
Hi,
Here is what I want to do
I want to search local directory and its sub directory, all the files which contain any string like _12345, then remove this string.
String is a combination of _ plus a random integer number.
For example, here is one line in a file before
<properties... (1 Reply)
Discussion started by: bp5000
1 Replies
6. Shell Programming and Scripting
Dear all,
I need your help, I have file like this:
file1:23456
01910964830098775635
34567
01942809546554654323
67589
26546854368698023653
09778
58716868568576876878
08675
86178546154065406546
08573
54165843543054354305
.
.file2:
23456 25
34567 26
67589 27 (2 Replies)
Discussion started by: attila
2 Replies
7. Shell Programming and Scripting
Hi,
Here's my dilemma.
I need to replace the string Sept_2012 to Oct_2012 in all *config.py files within the current directory and below directories
Is this possible?
Also I am trying to find all instances of the string Sept_2012 within files in the current directory and below
I have... (13 Replies)
Discussion started by: pure_jax
13 Replies
8. Solaris
Dear All
I need to find and replace a string in a set of files. I try as :
#find / -name "*"|xargs grep "Tektra"|grep -v "Tektra GSM BTS"
But it doesn't work. It just finds the string in the files. I need to find and replace it.Can you please let me know how to correct it?
Thank you (2 Replies)
Discussion started by: hadimotamedi
2 Replies
9. UNIX for Beginners Questions & Answers
HI there,
I am trying to find and replace with wildcard with
data
chr1 69511 69511 A G 1/1:0,34:791,78,0:78:34 0/1:55,60:1130,0,1513:99:116 1/1:0,28:630,63,0:63:28 0/1:0,34:626,57,0:57:34
To this
chr1 69511 69511 A G homo hetero homo hetero
Where I find and replace 0/1 with... (3 Replies)
Discussion started by: daashti
3 Replies
10. Shell Programming and Scripting
Hi,
I know how to replace a string with another in a file.
But, i wish to replace the below string pattern
EncryptedPassword="{gafgfa}]\asffafsf312a" i.e EncryptedPassword="<any random string>"
To
EncryptedPassword=""
i.e remove the random password to a empty string.
Can you... (3 Replies)
Discussion started by: mohtashims
3 Replies
LEARN ABOUT CENTOS
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)