Jump to content
Macro Express Forums

sorlov

Members
  • Posts

    4
  • Joined

  • Last visited

sorlov's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. OMG!!! I edited the file location, clicked on "Test Run Macro" and, at first, thought it's still waiting, while it has already finished. Your macro was so fast! And so efficient. As a librarian, I have to work with text a lot, so handling it is a must. This macro does it very well. If you have time for a macro using external reg expressions, it would be great, but even w/o it, you saved me lots of time and headache Thanks a lot!
  2. Just a list of the "a66########" numbers will do.
  3. Please find attached. This file can be opened in any text editor, including Notepad, but I'm using EditPlus becayse I need to include the regular expression a66[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9] in search. I'm looking for electronic ISBNs, and since the file has a couple varieties of those (some are 13 and some are 10 digits long), I need to find those with "a66" in the beginning and having 10 digits after the "a". If you use another editor, the macro could be edited for use with EditPlus, right? SPRHum1.zip
  4. 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
×
×
  • Create New...