Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2015, 01:54 PM
macropod's Avatar
macropod macropod is offline Extract Data From Text file based on Pattern Windows 7 64bit Extract Data From Text file based on Pattern Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
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

An 800MB text file is way too large to process - I'm not even sure Word could open it. The published limit is 512MB with no more than 32MB of text. I suggest you use another app to filter the data to eliminate everything that doesn't match your US/RE pattern. You may even need to break those up into smaller chunks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-23-2015, 09:57 AM
PRA007's Avatar
PRA007 PRA007 is offline Extract Data From Text file based on Pattern Windows 7 32bit Extract Data From Text file based on Pattern Office 2010 32bit
Competent Performer
Extract Data From Text file based on Pattern
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default Extract Data from Text file based on Pattern Match

I was able to cut the large file to small based on the pattern. I used word wild card search to find patent numbers and made a txt file neming small

I found answers from superuser to cut the file for what I want

http://superuser.com/questions/99066...search-pattern
grep -f small_list.txt big_file.txt

Now I have made the resultant file in excel having only 3 column
1st column containing Patent numbers, second for event date and last for event code.
Is it possible with small files to do the above task

I also created word document having table with same as excel file if thats easy to be used.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract Data From Text file based on Pattern How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM
Retrieving data from data base based on text selection capitala PowerPoint 0 12-10-2014 08:10 AM
Extract Data From Text file based on Pattern Inserting text from one word file into another based on an excel input jmaxcy Excel 14 11-01-2013 04:07 PM
Inserting text from one word file into another based on an excel input jmaxcy Word 3 11-01-2013 01:26 AM
Is there a way to do this? (automatically enter text based on form data) TIKKI555 Word 0 05-26-2010 09:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:23 PM.


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