How do I find and replace a part of a string variable in Stata?

Question

I am working with a variable which is basically URLs. So observations include values like for example

www.google.com
https://www.google.com
https://yahoo.movies.com

I am trying to create a do file to import a bunch of these files into Stata and need a reliable method to remove the www. and the https:// parts from these variables over a wide range of URLs.

In Excel I can do this simply by finding https:// or www. and replacing it with nothing, how do I achieve the same in Stata?

I am working in Stata 13.1 SE on Windows 8 Pro 64 bit.

herohuyongtao · Accepted Answer · 2014-01-23 16:47:17Z

5

You can use subinstr() function.

Example:

subinstr("this is this","is","X",.) = "thX X thX"

answered Jan 23, 2014 at 16:47

herohuyongtao

50.9k30 gold badges138 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I find and replace a part of a string variable in Stata?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related