Deleting URLs

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Crunching
Posts: 3
Joined: Fri Mar 12, 2010 1:35 pm

Deleting URLs

Post by Crunching »

How to delete URL from a line and leave only the text.

For example -
The cat is in the bag ... http://bit.ly/btEcow

to become -
The cat is in the bag ...

To do this In Excel it is
Find: http:*
Replace: (leave empty)

What is the procedure to do this in TextPipe?
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Deleting URLs

Post by DataMystic Support »

Find perl pattern: http[^\r\n]*?
Replace with: <blank>
Crunching
Posts: 3
Joined: Fri Mar 12, 2010 1:35 pm

Re: Deleting URLs

Post by Crunching »

This procedure gives the answer -
The cat is in the bag ... ://bit.ly/btEcow

But looking to give answer -
The cat is in the bag ...
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Deleting URLs

Post by DataMystic Support »

ok, use

Find perl pattern: http[^\r\n]*

or uncheck the option to do greedy matching.
Crunching
Posts: 3
Joined: Fri Mar 12, 2010 1:35 pm

Re: Deleting URLs

Post by Crunching »

Thank you for your assistance.
Post Reply