Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Using FIND with case insensitive search

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Using FIND with case insensitive search
# 1  
Old 10-27-2011
Using FIND with case insensitive search
I am using HP-Unix B.11.31.

Question: How to do the case insensitive search using FIND?

Example: I would like list the files with extension of *.SQL & *.sql.
When I try with command find . -type f -name *.sql, it does not lists file with *.SQL.
# 2  
Old 10-27-2011
Anything you tried yourself?
Code:
find . -type f -name "*.[sS][qQ][lL]"
# or
find . -type f| grep -i sql

This User Gave Thanks to zaxxon For This Post:
Siva SQL
# 3  
Old 10-27-2011
Use "-iname" option for case-insensitive match.

Code:
find . -type f -iname "*.sql"

# 4  
Old 10-27-2011
I get error find: bad option -iname, if i use -iname.

$ find . -type f -iname "*.sql"
find: bad option -iname
# 5  
Old 10-27-2011
Quote:
Originally Posted by Siva SQL
I get error find: bad option -iname, if i use -iname.

$ find . -type f -iname "*.sql"
find: bad option -iname
I think this option is not available in HP-UX. It is OK in Linux.
# 6  
Old 10-27-2011
Quote:
Originally Posted by zaxxon
Anything you tried yourself?
Code:
find . -type f -name "*.[sS][qQ][lL]"
# or
find . -type f| grep -i sql

Thanks both commands work like charm!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Using awk to search case insensitive

Hello , Using the below scrip to search a string in a file , by case-insensitively Please assist on using the toupper() as getting error !. #!/usr/bin/ksh set -x curr_dir=`pwd` file_ctr=0 printf "\n Reviewing the output file from the directory: %s \n\n" $curr_dir ls -latr ... (4 Replies)
Discussion started by: Siva SQL
4 Replies

2. Shell Programming and Scripting

Case insensitive file name search and replace

I am trying to find case insensitive file names and then replace that particular file with other name. if then ls | grep -i "update" | xargs -I {} mv {} LineItems.csv echo "File moved from *update*" elif then ls | grep -i "priority" | xargs -I {} mv {} ... (1 Reply)
Discussion started by: ATWC
1 Replies

3. UNIX for Dummies Questions & Answers

Command for a case insensitive search

Hi All, What is the command to search a file for a case-insensitive match 1.grep -nc text filename 2.grep -i text filename 3.grep -i filename text 4.grep -nc filename text 5.grep -c text filename Thanks for your help (1 Reply)
Discussion started by: bobby1015
1 Replies

4. UNIX for Dummies Questions & Answers

Using sed for case insensitive search

Hi, I have a file named "test_file" that has the below content. It has words in upper/lower cases PRODOPS prodOPS ProdOps PRODops escalate Shell My requirement is to replace all the "prodops" (what ever case it may be) with "productionoperations". I tried using the "i" option with... (7 Replies)
Discussion started by: sbhuvana20
7 Replies

5. AIX

Case insensitive search in AIX man ?

Hello, Linux man command search is case insensitive by default, but not AIX man. How do I serch case insensitive while using AIX manual pages ? thanks Vilius (7 Replies)
Discussion started by: vilius
7 Replies

6. UNIX for Dummies Questions & Answers

more command case insensitive search ?

Hello, How do I set case insensitive search mode while the file is open with more command ? (I know -i option which could be used before opening) thanks Vilius (2 Replies)
Discussion started by: vilius
2 Replies

7. Shell Programming and Scripting

Case Insensitive search

Hey , i am trying to do a search for the certain books , and im trying to make it case insensitive. what i have come up with so far is this : Database.txt RETARDED MONKEY:RACHEAL ABRAHAML:30:30:20 GOLD:FATIN:23.20:12:3 STUPID:JERLYN:20:40:3 echo -n "Title: " read Title echo -n... (3 Replies)
Discussion started by: gregarion
3 Replies

8. Shell Programming and Scripting

PHP Compare 2 Arrays find difference & case insensitive

Hi, I need an elegant solotion in php. I need to compare 2 arrays (array1 & array2), to find all instances of array 2 which is not in array1. I don't want to see any instances of array1 wich is not in array2 (here "the") Array1: This, is, the, data, of, array1 Array2: this, is, data, Of,... (2 Replies)
Discussion started by: lowmaster
2 Replies

9. Shell Programming and Scripting

case-insensitive search with AWK

Hi All, How we can perform case-insensitive search with AWK.:rolleyes: regards, Sam (11 Replies)
Discussion started by: sam25
11 Replies

10. Shell Programming and Scripting

case insensitive

hi everyone, I need to do the following thing in a case insesitive mode sed 's/work/job/g' filename since work could appear in different form as Work WORK WorK wORK,.... I was wondering if i could do a case insensitive search of a word. thanks in advance, :) (4 Replies)
Discussion started by: ROOZ
4 Replies
Login or Register to Ask a Question