Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2014, 06:26 AM
subodhgupta subodhgupta is offline Search Multiple strings and create new word file Windows XP Search Multiple strings and create new word file Office XP
Novice
Search Multiple strings and create new word file
 
Join Date: May 2014
Posts: 2
subodhgupta is on a distinguished road
Default Search Multiple strings and create new word file

Dear All

Help required..

I have a word file of 42 pages which contains database of many people. I want to search the names with their surnames and want to create another word file which contains cells with desired surnames.
Each cell contains name (first name, surname), age, residential address of a person.
Each cell of the newly created word file should contain the complete information of the searched surname.
Surnames count :- 25 .
Multiple search also desired with minimum effort.

Find + replace option is very time consuming

Regards

Subodh Gupta
Reply With Quote
  #2  
Old 05-20-2014, 08:07 AM
macropod's Avatar
macropod macropod is offline Search Multiple strings and create new word file Windows 7 32bit Search Multiple strings and create new word file Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

And how is Word supposed to find all these details to create this database?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-20-2014, 11:07 PM
eNGiNe eNGiNe is offline Search Multiple strings and create new word file Windows 7 32bit Search Multiple strings and create new word file Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Sounds to me like a job for a spreadsheet, not a word-processor :-} arrange the information in columns on sheet 1, use a reference to pull just the information you want from each record into sheet 2.

Hope this helps!
Reply With Quote
  #4  
Old 05-21-2014, 01:11 AM
macropod's Avatar
macropod macropod is offline Search Multiple strings and create new word file Windows 7 32bit Search Multiple strings and create new word file Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Without knowing how the data are arranged in the document, even that might not get one any closer. Word has far more powerful data parsing tools than Excel (although one could invoke RegEx to extend Excel's abilities) and can do a good job of preparing the data for importing into Excel. Consider, for example:
http://www.vbaexpress.com/forum/show...-word-to-excel
http://social.technet.microsoft.com/...?forum=worddev
http://social.technet.microsoft.com/...forum=exceldev
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-22-2014, 03:34 AM
eNGiNe eNGiNe is offline Search Multiple strings and create new word file Windows 7 32bit Search Multiple strings and create new word file Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Without knowing how the data are arranged in the document
Indeed! and what OP intends to convey with the word 'cell'
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
search on multiple word documents Guy Roth Word 7 03-06-2017 01:31 PM
Search Multiple strings and create new word file Search Multiple strings and create new word sheet subodhgupta Word Tables 1 05-20-2014 08:09 AM
Search Multiple strings and create new word file Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
Search Multiple strings and create new word file How to create multiple pages, 1 instance of word window cs_starter Mail Merge 1 09-08-2011 12:52 AM
Search Multiple strings and create new word file update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft