Find similar entry in a .txt file acting as a database.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Find similar entry in a .txt file acting as a database.
# 1  
Old 01-26-2011
Find similar entry in a .txt file acting as a database.

May i know how do i go along finding similar entry in a .txt file, which is used a as a "database" and post and error saying the entry existed when we key in the entry.

---------- Post updated at 05:18 PM ---------- Previous update was at 05:16 PM ----------

i mean post an error saying the entry existed.
# 2  
Old 01-26-2011
Hi, could you make an example of your problem?
# 3  
Old 01-26-2011
Lets say there is this database "worker.txt" with john:25 where john is the name and 25 is the age.

The program will program to ask use to enter our entry.
Code:
echo -n "Name: "
read Name
echo -n "Age: "
read Age

from here, i enter John and then 25.

So how do i go about finding "John" and "25" in the worker.txt where John and 25 already existed. as is already existed, the program will prompt "Worker existed" for example. i having trouble going about finding similar entry in my .txt.

Last edited by Yogesh Sawant; 01-27-2011 at 07:42 AM.. Reason: added code tags
# 4  
Old 01-26-2011
You could test the return code from the grep
Code:
name="john"
age=25
file=txt
grep  -x ${name}:${age} $file 2>&1 > /dev/null

if [ "$?" -eq "0" ]; then
        echo "User exists"
fi

---------- Post updated at 12:02 PM ---------- Previous update was at 11:37 AM ----------

One subtle thing I noticed in your initial post - you asked to find "similar" entries, but please note that the -x flag for grep that I posted above will find exact matches. This is probably what you mean.

Last edited by dsw; 01-26-2011 at 07:01 AM.. Reason: oops, forgot code tags.
This User Gave Thanks to dsw For This Post:
# 5  
Old 01-27-2011
Yea, as there might be chances of 2 John but of different age, i must code in a way that they find the John of that particular age. In addition, is this the similar way to use for delete? just tat i have to change the -x to -v?
# 6  
Old 01-27-2011
Hi,

you would want both -x and -v, to ensure you omit the exact match.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk, sed, shell all words in INPUT.txt find in column1 of TABLE.txt and replce with column2 in

Hi dears i have text file like this: INPUT.txt 001_1_173 j nuh ]az 001_1_174 j ]esma. nuh ]/.xori . . . and have another text like this TABLE.txt j j nuh word1... (6 Replies)
Discussion started by: alii
6 Replies

2. HP-UX

Sudo entry required to set permission similar to ROOT without using password (PASSWD) change optio

Hi All I had installed sudo in HP UX 11.3 and it is working fine but not able to make entry required to set permission similar to ROOT without using password (PASSWD) change option for define user in /etc/sudoers file Please help if some know the syntex? :confused::wall: (2 Replies)
Discussion started by: deviltech
2 Replies

3. Shell Programming and Scripting

Add similar pairs in a txt file

Hi guys!!! In my txt file there are a lot of pairs. Some of them are similar, so I am trying to add these pairs. For a example: File: ASP - GLN = 14 SER - GLU = 14 ARG - ASN = 13 ARG - TYR = 13 ASP - ARG = 13 GLU - ARG = 13 GLU - GLN = 13 ALA - ARG = 12 ... (7 Replies)
Discussion started by: Tzole
7 Replies

4. Red Hat

How to find a garbage entry in a column wise text file in Linux?

Suppose I have a file containing :- 1 Apple $50 2 Orange $30 3 Banana $10 4 Guava $25 5 Pine@apple $12 6 Strawberry $21 7 Grapes $12 In the 5th row, @ character inserted. I want through sort command or by any other way this row should either on top or bottom. By sort command garbage... (1 Reply)
Discussion started by: Dipankar Mitra
1 Replies

5. UNIX for Dummies Questions & Answers

Statement to find if an entry exists in a file

I need to check if an entry input by the user is in a file. If so, I need to run a command, and if it does not exist then it should output entry does not exist. So I have so far... echo "Enter record:" read record //command || //command Can I use an if statement to do this? (3 Replies)
Discussion started by: itech4814
3 Replies

6. Shell Programming and Scripting

Perl program for find one entry and put in different file

Hi I have a file name1 xxxxx name1 xxxxx name1 yyyyy name 1 zzzzz name1 Uniprot Id 1234 name2 sssss name2 eeeee name2 bengamine name2 Uniprot Id 3456 ......................and so on I have to capture Uniprot IDs only in a separate file so that output contain only ... (20 Replies)
Discussion started by: manigrover
20 Replies

7. Shell Programming and Scripting

Using csh / awk / sed to compare database sizes in a txt file

Hello, I have an output file showing database sizes across the 3 environments that I use (LIVE, TEST & DEVELOPMENT). I am trying to write a script that lets me know if the size of a db on one environment is different to its corresponding db on the other environments. Here is an example... (4 Replies)
Discussion started by: stevie_g
4 Replies

8. UNIX for Dummies Questions & Answers

find lines in file1.txt not found in file2.txt memory problem

I have a diff command that does what I want but when comparing large text/log files, it uses up all the memory I have (sometimes over 8gig of memory) diff file1.txt file2.txt | grep '^<'| awk '{$1="";print $0}' | sed 's/^ *//' Is there a better more efficient way to find the lines in one file... (5 Replies)
Discussion started by: raptor25
5 Replies

9. Shell Programming and Scripting

txt file to oracle database

hiya, i have a query: i want to read a file which contains: 2005/02/21 16:56:54.301: 111 PS (200, 10) sent <log instrument="FXA.ROSS"... (9 Replies)
Discussion started by: jorhul
9 Replies

10. SCO

Terminal Control Database Entry

Hi, can someone pls help resolves this problem. I have an Openserver 5.0.4 running but had this error after having a power failure problem. error: cannot access termainl control database entry I have a arnetport also install with wyse 60 terminals, non of the users can have access on... (2 Replies)
Discussion started by: kayode
2 Replies
Login or Register to Ask a Question