sorlov Posted January 18, 2008 Report Share Posted January 18, 2008 Greetings! I am new to ME and have a question. I want to go through an *.mrc file, copy from it all ISBN numbers and paste into Excel. The *.mrc file is a file with bibliographic records which consists of one extremely long line with information on hundreds of books. No line breaks. I wrote a macro that opens the file in EditPlus, searches for a regular expression a66[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9], copies it and pastes into Excel. Works fine, but I don't know how to tell the program to stop. I'm not sure it would work with Text File Begin/End Process, since there are no line breaks. And I don't see what variable I could define to use in Repeat Until since it's just one long stream of data. Is there a way to tell the program just to stop looping when there is no more text left? If not, what would you suggest? Thanks in advance, Stanislav Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.