Visit Our UNIX and Linux User Community


Want to read data from a file name.txt and search it in another file and then matching...


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Want to read data from a file name.txt and search it in another file and then matching...
# 1  
Old 01-31-2012
Want to read data from a file name.txt and search it in another file and then matching...

Hi Frnds...
I have an input file name.txt and another file named as source.. name.txt is having only one column and source is having around 25 columns...i need to read from name.txt line by line and search it in source file and then save the result in results file..
I have a rough idea about the same...that a loop should be taken for the same and it searching can be done by awk filter as source file is quite big...and then the output can be redirected to results..
can someone plzz help me out with this..

~Thanks
Priya...SmilieSmilie
# 2  
Old 01-31-2012
Hi,

if I understood what u're looking to accomplish:
Code:
for currline in `cat name.txt`
do
grep "${currline}" source >> result
done

you may test the procedure on a subset of the whole data to check if it's consistent with your needs

see ya
fra
# 3  
Old 01-31-2012
Quote:
Originally Posted by frappa
Hi,

if I understood what u're looking to accomplish:
Code:
for currline in `cat name.txt`
do
grep "${currline}" source >> result
done

you may test the procedure on a subset of the whole data to check if it's consistent with your needs

see ya
fra
Thanks a lot buddy...but i need to read the file as well..also the file from which i need to search the data is quite big so grep may get fail... Smilie
i m stuck with the use of awk here... Smilie
# 4  
Old 01-31-2012
ksh93 on Solaris:

Code:
#!/usr/dt/bin/dtksh

#  Declare constants
typeset -r RESULTSFILE=results
typeset -r INFILE=name.txt
typeset -r SOURCEFILE=source

#  Clear or create output file.
> $RESULTSFILE

while read line_in
do
  print "Search results for [${line_in}]:" >> $RESULTSFILE
  grep "$line_in" $SOURCEFILE >> $RESULTSFILE
done < $INFILE

exit 0

# 5  
Old 02-01-2012
Quote:
Originally Posted by gary_w
ksh93 on Solaris:

Code:
#!/usr/dt/bin/dtksh

#  Declare constants
typeset -r RESULTSFILE=results
typeset -r INFILE=name.txt
typeset -r SOURCEFILE=source

#  Clear or create output file.
> $RESULTSFILE

while read line_in
do
  print "Search results for [${line_in}]:" >> $RESULTSFILE
  grep "$line_in" $SOURCEFILE >> $RESULTSFILE
done < $INFILE

exit 0

hi buddy..thanks for the same...but it is not searching the msisdn i.e. numbers present in the name.txt file...i feel we need to use grep or awk for the same...plzz some1 help me out wid d same... Smilie
# 6  
Old 02-01-2012
Quote:
Originally Posted by ektubbe
hi buddy..thanks for the same...but it is not searching the msisdn i.e. numbers present in the name.txt file...i feel we need to use grep or awk for the same...plzz some1 help me out wid d same... Smilie
It will be great for us as well to see the Sample input file, data file and ur expected output. Like this, all can only give wild guesses and you will all the time end up banging your head on the wall Smilie like the way you are doing for past few posts Smilie Smilie
# 7  
Old 02-01-2012
Data

Quote:
Originally Posted by knight_eon
It will be great for us as well to see the Sample input file, data file and ur expected output. Like this, all can only give wild guesses and you will all the time end up banging your head on the wall Smilie like the way you are doing for past few posts Smilie Smilie
Here is the data file name.txt :
Code:
msisdn
--------------
09311424354
09128734473
09487736472

source file :
Code:
msisdn             | imsi | name | subscription | product | date | recharge type
09311424354 | 09488439820 | ekta | yes | VAS | 2012-12-07 | IVR
09128734473 | 83974738734 | priya | no | Non VAS | 2011-08-11 | SMS
09376536263 | 63473627632 | shubhra | yes | VAS | 2011-07-07 | WAP
09655423434 | 13312353343 | shubhi | no | non VAS | 2011-05-04 | SMS
09473874383 | 36267267372 | amita | yes | VAS | 2011-04-05 | IVR

now i want to sort this source file on the basis of msisdn present in name.txt and output should be stored in output file as given below :
Code:
msisdn             | imsi | name | subscription | product | date | recharge type
09311424354 | 09488439820 | ekta | yes | VAS | 2012-12-07 | IVR
09128734473 | 83974738734 | priya | no | Non VAS | 2011-08-11 | SMS

As these are the matching values.
See if you can help out with it.....it would be A great help .....
~Thanks
Priya...Smilie

Last edited by Franklin52; 02-01-2012 at 04:06 AM.. Reason: Please use code tags for code and data samples, thank you

Previous Thread | Next Thread
Test Your Knowledge in Computers #732
Difficulty: Easy
In BASIC, GOTO jumps to a numbered or labelled line in the program.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get the shell script to read the .txt file as an input/data?

i have written my shell script in notepad however i am struggling to pass the data file to be read to the script the data file is of .txt format. My target is to run the shell script from the terminal and pass 3 arguments e.g. polg@DESKTOP-BVPDC5C:~/CS1420/coursework$ bash valsplit.sh input.txt... (11 Replies)
Discussion started by: Gurdza32
11 Replies

2. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

3. Shell Programming and Scripting

create txt file form data file

File A.txt LL07 LL07_B_1 20 LL85 LL85_A_1 40 LL85 LL85_B_1 40 LL85 LL85_C_1 30 LL37 LL37_A_1 60 LL37 LL37_B_1 20 LL37 LL37_C_1 50 I want cretae diffrent tex file base of above file Should be threee text file LL07.txt LL85.txt LL37.txt Eaach text file have below data... (2 Replies)
Discussion started by: asavaliya
2 Replies

4. Shell Programming and Scripting

create txt file form data file and add some line on it

Hi Guys, I have file A.txt File A Data AK1521 AK2536 AK3164 I want create text file of all data above and write some data on each file. want Output on below folder /home/kka/out AK1521.txt Hi Welocme (3 Replies)
Discussion started by: asavaliya
3 Replies

5. Shell Programming and Scripting

Get Data From CSV File and put into a txt file

Hi Guys, File A I have File A as CSV Format.... No R SS MK Par value S AL A1 PKL123 Lo12 1 S AL A2 PKl123 Lo34 22 S AL A3 PkLK234 Lo67 -34 S AL A4 PkLK235 Lo09 120 S AL A5 PkLK236 Lo76 19 S AL A6 PkLK237 Lo44 -17 S AL A7 PkLK238 Lo90 2 S AL A8 PkLK239 Lo34 -9 I want file B like... (4 Replies)
Discussion started by: asavaliya
4 Replies

6. Shell Programming and Scripting

shellscript to read data from txt file and import to oracle db

Hi all, Help needed urgently. I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins). I guess it takes so long... (1 Reply)
Discussion started by: robot_mas
1 Replies

7. Shell Programming and Scripting

Script to read file and extract data by matching pattern

Hello, I have a file ( say file1) which has lines like below. xxxx:xxxx,yyyy,1234,efgh zzzz:zzzz,kkkk,pppp,1234,xxxx,uuuu,oooo dddd:dddd here the word before ":" ( ie: xxxx) is the file name and the string after : are also file names, but each file name separated by "," In case of... (20 Replies)
Discussion started by: pradeepmacha
20 Replies

8. UNIX for Dummies Questions & Answers

can't read a .txt file

Hello, I have a set of .txt files I cannot read. This is a part of what I see. Is there a way to view these files? _MO<P.6D@K;WU<B$X-;)SIV/ROO!UL+1P=VTT-?,SLC`MI/6QMS#UYGGT\+)C=#\UIO`TL/0]=#/T) it's about 3 pages. Thanks for your help. Joe (3 Replies)
Discussion started by: rcracerjoe
3 Replies

9. Shell Programming and Scripting

unix script to takes the old data from a TXT file and compress them into new file

Hi, I am looking for the unix script which can takes the 2 month old data from a TXT file (there is one txt file in whiche messages are appended on daily basis) and compress them into new file.Please halp me out. (2 Replies)
Discussion started by: vpandey
2 Replies

10. UNIX for Dummies Questions & Answers

How to read last line of a txt file?

I need to read the last file for a particular day, such as, "Jun 13" because the CSV file is cumulative for the entire day, so I don't want all the previous files, I just want the last file, for that day. I ran an 'ls -al | grep "June 13" > myLs.txt' (simplified) to list all files from that day.... (2 Replies)
Discussion started by: yongho
2 Replies

Featured Tech Videos