PDA

View Full Version : Extract string from Text file



14-06-2002, 01:26 PM
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

14-06-2002, 02:55 PM
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.

14-06-2002, 04:57 PM
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.