String Manupulation with test data.

sdorsett

I have a table column that contains URLs. In another column in the same table I would like to extract the domain from the URL in the previous column. For example,

URL Domain
http://www.test.com test.com
http://www.abc.com abc.com

How would I go about pulling this off in the Data Generator?

sdorsett

Any help would be greatly apreciated here. Is there any native functions that support string manipulation. Is the code generator my only option?

To recap,
I want the second column to be a substring of the first column.

Linda Hawksworth

I don't think any of the generators will do this but I will investigate how it could be done with a custom generator. Please bear with me.

sdorsett

For the case provided, yes. Ideally I am looking for a string manipulation code generator.

Here is the scenario, I would like to generate a table of data where the first column is a list of specified URLs. The second column would be just the domain part of the URL in the first column, the third column would be any query information that was a part of the URL.

For example,

Column1 | Column2 | Column3
http://www.test.com/home.asp?id=3 | test.com | ?id=3
http://www.home.com/home.asp?id=1 | home.com | ?id=1
http://www.abcd.com/home.asp?id=4 | abcd.com | ?id=4
http://www.test.com/home.asp?id=5 | test.com | ?id=5
http://www.crazy.com/home.asp?id=6 | crazy.com | ?id=6

sdorsett

I did find a solution to my problem. Here is what I did.

I was shooting for a generated table that looked like the following.



Here is what the files look like.







I didn’t want to create the ReferrerDomainList and ReferrerURLList. I was hoping to dynamically create the entries via some string manipulation function provided by RedGate. No worries, maybe you can provide this in a future release.

Thanks for your assistance.


Sean Dorsett
http://www.slackytidy.com
L O O S E L Y C O U P L E D & C L E A N C O D E