Solved

Removing Unwanted characters from a text file.

Posted on 2013-06-06
1
302 Views
Last Modified: 2013-06-06
I figure this is a simple regex recipe, but I haven't been able to find the right one yet. I have a text file, and I want to remove all instances of 1-2 digits separated by a colon followed by 1-2 digits. So anything that looks like:

1:1
10:10
10:1
1:10
0
Comment
Question by:stakor
1 Comment
 
LVL 35

Accepted Solution

by:
Terry Woods earned 500 total points
ID: 39227579
Something like this? Don't forget to back up your file before testing, though the -i.bak option should make a backup with a .bak extension.

perl -i.bak -pe 's/(?<!\d)\d\d?:\d\d?(?!\d)//g' my_input_file.txt

Open in new window

0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question