Comments
Sort by recent activity
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. / comments
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...
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 / comments
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 specifi...
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. [image]
Here is what the files look like. [image] [image] [image] [image] [image]
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 / comments
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 Referre...