Solved Advanced text editing software

quadrplax

New member
Member
Local time
3:46 PM
Messages
92
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
custom build
OS
Windows 7 Home Premium 64bit
CPU
AMD Phenom II X4 965 AM3 3.4Ghz 512KB 45NM 125W 4000MHZ
Motherboard
GIGABYTE GA-990FXA-UD3 AM3+ AMD 990FX SATA 6Gb/s USB 3.0 ATX
Memory
Mushkin 997008 DDR3 UDIMM (2x4GB) 8GB PC3-14900 1866MHZ 9-10
Graphics Card(s)
HIS Radeon HD 7870 2 GB (256-Bit) GDDR5 2x Mini-Displayport
Monitor(s) Displays
Dell U2414H, Dell E2014H
Screen Resolution
16:9 1920x1080, 16:9 1600x900
Hard Drives
Kingston HyperX 3K 120 GB SATA III 2.5-Inch 6.0 Gb/s Solid State Drive SH103S3/120G
Keyboard
Some old PS/2 one
Mouse
USB Kensignton
Internet Speed
5Mb/s Download, 1Mb/s Upload
Antivirus
Avast! Free Antivirus
Browser
Mozilla Firefox
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 Computer

Computer type
Laptop
Computer Manufacturer/Model Number
Toshiba Sattelite A665-S6092
OS
Windows 7 Ultimate x64
CPU
Intel Core i7-740QM
Memory
8 GB DDR3
Graphics Card(s)
NVIDIA GeForce 330GT
Screen Resolution
1366x768
Hard Drives
Samsung 840 SSD 500GB
1TB USB3 external HD
Cooling
Coolermaster Notepal U3 notebook cooling pad
Internet Speed
3mbps ASDL
Antivirus
ClamWin 0.98.7
Browser
Opera 12.17 x86 (main), Firefox 38 (sec), IE11 (last resort)
I would suggest Notepad++ or Editplus (Trial).
Both are very capable editors and are very good at what they do.
 

My Computer

Computer type
Laptop
Computer Manufacturer/Model Number
HP EliteBook 8530w Mobile Workstation
OS
Windows 7 Ultimate x64 (XP, 98SE, 95, 3.11, DOS 7.10 on VM) + Ubuntu 10.04 LTS Lucid Lynx
CPU
Intel Core 2 Duo Processor P8600 (2.40 GHz, 3 MB L2 cache)
Motherboard
Mobile Intel PM45 Express Chipset ICH9M-Enhanced
Memory
4GB 800 MHz DDR2 SDRAM
Graphics Card(s)
ATI Mobility FireGL V5700 with 256 MB
Sound Card
SoundMAX Integrated Digital HD Audio
Monitor(s) Displays
15.4-inch WXGA anti-glare (1280 x 800 resolution)
Screen Resolution
1280 x 800
Hard Drives
500GB + 1TB
Mouse
Synaptics PS/2 Port Touchpad, USB Mouse
Internet Speed
4 Mbps
Antivirus
MSE
Browser
Firefox, Chrome, IE
Other Info
Authentec AES2810 Fingerprint Reader
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
custom build
OS
Windows 7 Home Premium 64bit
CPU
AMD Phenom II X4 965 AM3 3.4Ghz 512KB 45NM 125W 4000MHZ
Motherboard
GIGABYTE GA-990FXA-UD3 AM3+ AMD 990FX SATA 6Gb/s USB 3.0 ATX
Memory
Mushkin 997008 DDR3 UDIMM (2x4GB) 8GB PC3-14900 1866MHZ 9-10
Graphics Card(s)
HIS Radeon HD 7870 2 GB (256-Bit) GDDR5 2x Mini-Displayport
Monitor(s) Displays
Dell U2414H, Dell E2014H
Screen Resolution
16:9 1920x1080, 16:9 1600x900
Hard Drives
Kingston HyperX 3K 120 GB SATA III 2.5-Inch 6.0 Gb/s Solid State Drive SH103S3/120G
Keyboard
Some old PS/2 one
Mouse
USB Kensignton
Internet Speed
5Mb/s Download, 1Mb/s Upload
Antivirus
Avast! Free Antivirus
Browser
Mozilla Firefox
Back
Top