Red Gate forums :: View topic - String Manupulation with test data.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

String Manupulation with test data.

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sdorsett



Joined: 26 Aug 2008
Posts: 4

PostPosted: Tue Aug 26, 2008 6:36 am    Post subject: String Manupulation with test data. Reply with quote

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?
Back to top
View user's profile Send private message
sdorsett



Joined: 26 Aug 2008
Posts: 4

PostPosted: Thu Aug 28, 2008 7:29 am    Post subject: Need help Reply with quote

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.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Thu Aug 28, 2008 12:24 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
sdorsett



Joined: 26 Aug 2008
Posts: 4

PostPosted: Fri Aug 29, 2008 3:07 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
sdorsett



Joined: 26 Aug 2008
Posts: 4

PostPosted: Thu Sep 11, 2008 7:51 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group