Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Advanced text editing software

19 Mar 2014   #1

Windows 7 Home Premium 64bit
Advanced text editing software

I have a large list in a text file (roughly 900 items) and I want to do a few things to the list. First, I want to remove everything after a space on each line, including the spaces themselves. Then, I want to remove every line that does not have the either of these formats:
  • ***kAA**
  • ***kA**
Where "k" is the actual letter "k", "A" represents a random lowercase letter, and "*" represents a random number. Does anyone know a good program/web tool I can use to accomplish this?

My System SpecsSystem Spec

19 Mar 2014   #2

Windows 7 Ultimate x64

The first thing is trivial, even something as rustic as the built-in notepad can handle this, with the search and replace function.
For the second point, I'm pretty sure that a regular expression search can do the trick, again with a search and replace. I don't know regular expressions myself but possibly that tool will fit that search. I use Notepad2 myself and it can do that, and Notepad++ is another very capable editor.
My System SpecsSystem Spec
19 Mar 2014   #3

Windows 7 Ultimate x86 build 7600 (XP, 98SE, 95, 3.11, DOS 7.10 on VM) + Ubuntu 10.04 LTS Lucid Lynx

I would suggest Notepad++ or Editplus (Trial).
Both are very capable editors and are very good at what they do.
My System SpecsSystem Spec

20 Mar 2014   #4

Windows 7 Home Premium 64bit

I downloaded Notepad++, but how do you type an unknown letter/number in find/replace? Also, I'm pretty sure you can't do the first one in Notepad because of the "and everything after" part.

EDIT: Just found an inefficient way to do part 1 with macros, so that one doesn't matter now
EDIT2: I figured out the wildcard character, closing topic
My System SpecsSystem Spec

 Advanced text editing software

Thread Tools

Similar help and support threads for2: Advanced text editing software
Thread Forum
Excel advanced conditional editing help needed Microsoft Office
Protecting permission editing on a text file General Discussion
text editing General Discussion
Any Text editing software which I can copy formatting to blog post. Software
No "Turn off advanced text services” option for windows 7? General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 09:52 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33