Forum Home
Press F1
Thread ID: 20912	2002-06-14 01:26:00	Extract string from Text file	Guest (0)	Press F1

Post ID	Timestamp	Content	User
54305	2002-06-14 01:26:00	I havea large text file (25M) that I can't open completly in excel. I need to extract a number of strings of information starting wit <CT> and the following 20 character. Each string to be stored as a line in excel or equivalent Thanks	Guest (0)
54306	2002-06-14 02:55:00	Try opening it in word (or any text editor that will handle file size) Split the file at logical points and save to smaller files to open in excel. Make sure you save as text. I do this often with data that exceeds excel capabilities.	Guest (0)
54307	2002-06-14 04:57:00	There is a very useful Unix utility called 'grep' which will do this if run with the appropriate options. There are versions which run in DOS.	Guest (0)
1