DataMystic

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?

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

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 ...

ok, use

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

or uncheck the option to do greedy matching.

Thank you for your assistance.