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?
Deleting URLs
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: Deleting URLs
Find perl pattern: http[^\r\n]*?
Replace with: <blank>
Replace with: <blank>
Re: Deleting URLs
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 ...
The cat is in the bag ... ://bit.ly/btEcow
But looking to give answer -
The cat is in the bag ...
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: Deleting URLs
ok, use
Find perl pattern: http[^\r\n]*
or uncheck the option to do greedy matching.
Find perl pattern: http[^\r\n]*
or uncheck the option to do greedy matching.
Re: Deleting URLs
Thank you for your assistance.