04-27-2011
Need to find a string in files
Hi,
I have a directory nsk,
files a.sql, b.sql, c.sql, d.sql,
assuming that I have line 'INSERT ALL INTO abc' in a.sql and c.sql
I need to list a filename, line number and complete line which contains ''INSERT ALL INTO abc' irrespective of case.
also in my files mentioned 'INSERT ALL INTO abc' may be splitted into 4 lines/3 lines i.e., it may not be in single line
'INSERT ALL INTO abc' can be present as 'INSERT
ALL INTO abc'
'INSERT ALL INTO abc' can be present as 'INSERT ALL
INTO
abc'
So, please provide me the command which gives the above command satisfying the above requirements,
Thanks for your help in advance,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I used the following script
cd pathname
for y in `ls *`;
do sed "s/ABCD/DCBA/g" $y > temp; mv temp $y;
done
and it worked fine for finding and replacing strings with names etc. in all files of the given path.
I'm trying to replace a string which consists of path (location of file)
... (2 Replies)
Discussion started by: pharos467
2 Replies
2. Shell Programming and Scripting
Hi,
I would like to know how to get a list of files that contain a specific string inside them.
Thanks (12 Replies)
Discussion started by: yoavbe
12 Replies
3. Shell Programming and Scripting
Hi,
I have a directory has DIR1 and the D1 directory has 200+ files.
I want change the string from "Bangalore" to "Bangaluru" in all files in the D1 directory.
Thanks (2 Replies)
Discussion started by: koti_rama
2 Replies
4. Shell Programming and Scripting
Hello friends,
I have find a paticular string from the files present in my user
for example:
a username and password is hardcoded in multiple files which present in the my user.so I have to search about username in which files it is available.there are several dirctories are there,so... (5 Replies)
Discussion started by: sivaranga001
5 Replies
5. Shell Programming and Scripting
Hi,
I'm fairly new to UNIX, but hopefully some-one can help me with this:
I am using the following code to find files with the name "example.xml":
find . -name "example.xml" -print
that would print me a list like the example here:
./dir1/dir2/example.xml... (5 Replies)
Discussion started by: boijie
5 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I am still learning my way around unix commands and I have the following question.
I have a website and I want to search for all the html pages that don't contain a certain js file. The file I am searching for is located under /topfolder/js/rules.js . So I assume in my grep search I... (5 Replies)
Discussion started by: SyphaX
5 Replies
7. Shell Programming and Scripting
I have more than 100 files like this:
SVEAVLTGPYGYT 2
SVEGNFEETQY 10
SVELGQGYEQY 28
SVERTGTGYT 6
SVGLADYNEQF 21
SVGQGYEQY 32
SVKTVLGYEQF 2
SVNNEQF 12
SVRDGLTNSPLH 3
SVRRDREGLEQF 11
SVRTSGSYEQY 17
SVSVSGSPLQETQY 78
SVVHSTSPEAF 59
SVVPGNGYT 75 (4 Replies)
Discussion started by: xshang
4 Replies
8. Ubuntu
I have tried just about every find and grep command possible and I cannot find these damn files!!
This is the problem:
On the node you just swapped in, there are 5 JPEG files whose names contain the word "intro" in some form. Find all five files from on the entire disk (i.e. from root /).
... (2 Replies)
Discussion started by: dukeu69
2 Replies
9. Shell Programming and Scripting
Hi. I m trying to figure out how to do this.
I have a directory full of files (100 files) and I want to be able to search for a string called "end" at the end of the files (last line or last 5 lines) and echo each file to say "incomplete" if not found.
This is what I have so far.
---... (4 Replies)
Discussion started by: jasonhawaii
4 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I need to write a script to find all "*.sh" files in /home file system and if any string find "*.sh" files with the name vijay@gmail.com need to replace with vijay.bhaskar@gmail.com. I just understood about the find the command to search .sh files. Please help me on this.
find / -name... (3 Replies)
Discussion started by: bhas85
3 Replies
LEARN ABOUT DEBIAN
mdb-sql
MDBTools(1) MDBTools(1)
NAME
mdb-sql - SQL interface to MDB Tools
SYNOPSIS
mdb-sql [-HFp] [-d delimiter] [-i file] [-o file] [database]
DESCRIPTION
mdb-sql is a utility program distributed with MDB Tools.
mdb-sql allows querying of an MDB database using a limited SQL subset language.
OPTIONS
-H Supress header row.
-F Supress footer row.
-p Turn off pretty printing. By default results are printed in an ascii table format which looks nice but is not conducive to manipu-
lating the output with unix tools. This option prints output plainly in a tab separated format.
-d Specify an alternative column delimiter. If no delimiter is specified, columns will be delimited by a tab character if pretty print-
ing (-p) is turned off. If pretty printing is enabled this option is meaningless.
-i Specify an input file. This option allows an input file containing the SQL to be passed to mdb-sql. See Notes.
-o Specify an output file. This option allows the name of an output file to be used instead of stdout.
COMMANDS
mdb-sql in interactive mode takes some special commands.
connect to <database>
If no database was specified on the command line this command is necessary before any querys are issued. It also allows the switch-
ing of databases once in the tool.
disconnect
Will disconnect from the current database.
go Each batch is sent to the parser using the 'go' command.
reset A batch can be cleared using the 'reset' command.
list tables
The list tables command will display a list of available tables in this database, similar to the mdb-tables utility on the command
line.
describe table <table>
Will display the column information for the specified table.
quit Will exit the tool.
SQL LANGUAGE
The currently implemented SQL subset is quite small, supporting only single table queries, no aggregates, and limited support for WHERE
clauses. Here is a brief synopsis of the supported language.
select:
SELECT [* | <column list>] FROM <table> WHERE <where clause>
column list:
<column> [, <column list>]
where clause:
<column> <operator> <literal> [AND <where clause>]
operator:
=, =>, =<, <>, like, <, >
literal:
integers, floating point numbers, or string literal in single quotes
NOTES
When passing a file (-i) or piping output to mdb-sql the final 'go' is optional. This allow constructs like
echo "Select * from Table1" | mdb-sql mydb.mdb
to work correctly.
The -i command can be passed the string 'stdin' to test entering text as if using a pipe.
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
HISTORY
mdb-sql first appeared in MDB Tools 0.3.
SEE ALSO
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)
AUTHORS
The mdb-sql utility was written by Brian Bruns.
BUGS
The supported SQL syntax is a very limited subset and deficient in several ways.
0.7 13 July 2013 MDBTools(1)