Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Grepping a list of words from one file in a master database of homophones
Top Forums Shell Programming and Scripting Grepping a list of words from one file in a master database of homophones Post 302879324 by Chubler_XL on Wednesday 11th of December 2013 09:57:40 PM
Old 12-11-2013
For output like this:

Code:
John(2003) : Jon Jean John Johan Johann
Mary(21978) : Mary Marie Mariam Marium

try:
Code:
awk 'FNR==NR {H[$1]=$2; L[$2]=L[$2]" "$1 ; next }
{ print $1"(" H[$1]") : "substr(L[H[$1]],2) } ' homophones names

---------- Post updated at 12:57 PM ---------- Previous update was at 12:54 PM ----------

For your listed output try:

Code:
awk 'FNR==NR {H[$1]=$2; L[$2]=L[$2]" "$1 ; next }
{ print $1":"
  for(i=split(L[H[$1]], r);i;i--)
     print r[i]"\t"H[$1] } ' homophones names

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List all file names that contain two specific words.

Hi, all: I would like to search all files under "./" and its subfolders recursively to find out those files contain both word "A" and word "B", and list the filenames finally. How to realize that? Cheers JIA (18 Replies)
Discussion started by: jiapei100
18 Replies

2. Shell Programming and Scripting

Splitting Concatenated Words in Input File with Words from a Master File

Hello, I have a complex problem. I have a file in which words have been joined together: Theboy ranslowly I want to be able to correctly split the words using a lookup file in which all the words occur: the boy ran slowly slow put child ly The lookup file which is meant for look up... (21 Replies)
Discussion started by: gimley
21 Replies

3. Shell Programming and Scripting

indexing list of words in a file

Hey all, I'm doing a project currently and want to index words in a webpage. So there would be a file with webpage content and a file with list of words, I want an output file with true and false that would show which word exists in the webpage. example: Webpage content data.html ... (2 Replies)
Discussion started by: Johanni
2 Replies

4. Shell Programming and Scripting

Grepping large list of files

Hi All, I need help to know the exact command when I grep large list of files. Either using ls or find command. However I do not want to find in the subdirectories as the number of subdirectories are not fixed. How do I achieve that. I want something like this: find ./ -name "MYFILE*.txt"... (2 Replies)
Discussion started by: angshuman
2 Replies

5. UNIX for Dummies Questions & Answers

Grepping Words with No Vowels

Hi! I was trying to grep all the words in a wordlist, (twl), with no vowels. I had a hard time figuring out how to do it, but I finally lit on the -v flag. Here's my question: Why does this work: grep -v '' twl But this doesn't: grep '' twl In the second example, we're asking for lines... (6 Replies)
Discussion started by: sudon't
6 Replies

6. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies

7. Shell Programming and Scripting

Identifying single words in a dictionary database

I am reworking a Marathi-English dictionary to be out on open-source. My dictionary has the Headword in Marathi, followed by its Part of Speech and subsequently by its English glosses as in the examples below; अकरसणें v i To contract, shrink. अकरा a Eleven. अकराळ a Frightful, terrible. विकराळ... (2 Replies)
Discussion started by: gimley
2 Replies

8. UNIX for Advanced & Expert Users

List all file names that contain two specific words. ( follow up )

Being new to the forum, I tried finding a solution to find files containing 2 words not necessarily on the same line. This thread "List all file names that contain two specific words." answered it in part, but I was looking for a more concise solution. Here's a one-line suggestion... (8 Replies)
Discussion started by: Symbo53
8 Replies

9. Shell Programming and Scripting

Regex to identify unique words in a dictionary database

Hello, I have a dictionary which I am building for the Open Source Community. The data structure is as under HEADWORD=PARTOFSPEECH=ENGLISH MEANING as shown in the example below अ=m=Prefix signifying negation. अँहँ=ind=Interjection expressing disapprobation. अं=int=An interjection... (2 Replies)
Discussion started by: gimley
2 Replies

10. Shell Programming and Scripting

Deleting a list of words from a text file

Hello, I have a list of words separated by spaces I am trying to delete from a text file, and I could not figure out what is the best way to do this. what I tried (does not work) : delete="password key number verify" arr=($delete) for i in arr { sed "s/\<${arr}\>]*//g" in.txt } >... (5 Replies)
Discussion started by: Hawk4520
5 Replies

LEARN ABOUT REDHAT

drop_database

DROP 
DATABASE(7)						   SQL Commands 						  DROP DATABASE(7)

NAME

       DROP DATABASE - remove a database

SYNOPSIS

       DROP DATABASE name

   INPUTS
       name   The name of an existing database to remove.

   OUTPUTS
       DROP DATABASE
	      This message is returned if the command is successful.

       DROP DATABASE: cannot be executed on the currently open database
	      You  cannot  be connected to the database you are about to remove.  Instead, connect to template1 or any other database and run this
	      command again.

       DROP DATABASE: may not be called in a transaction block
	      You must finish the transaction in progress before you can call this command.

DESCRIPTION

       DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data.  It can only be  executed
       by the database owner (usually the user that created it).

       DROP DATABASE cannot be undone. Use it with care!

   NOTES
       This  command  cannot  be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
       [dropdb(1)], which is a wrapper around this command, instead.

       Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.

COMPATIBILITY

   SQL92
       DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.

SQL - Language Statements					    2002-11-22							  DROP DATABASE(7)
All times are GMT -4. The time now is 03:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy