Deleting URLs

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Deleting URLs

Postby Crunching » Fri Mar 12, 2010 1:51 pm

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: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Deleting URLs

Postby DataMystic Support » Mon Mar 15, 2010 1:31 pm

Find perl pattern: http[^\r\n]*?
Replace with: <blank>
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

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

Re: Deleting URLs

Postby Crunching » Tue Mar 16, 2010 2:18 pm

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: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Deleting URLs

Postby DataMystic Support » Tue Mar 16, 2010 3:22 pm

ok, use

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

or uncheck the option to do greedy matching.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

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

Re: Deleting URLs

Postby Crunching » Tue Mar 16, 2010 9:23 pm

Thank you for your assistance.


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest