String Manupulation with test data.

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

  sdorsett August 28, 2008 02:29

  - 0 +
• 
  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.

  Linda Hawksworth August 28, 2008 07:24

  - 0 +
• 
  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 August 29, 2008 10:07

  - 0 +
• 
  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

  sdorsett September 11, 2008 14:51

  - 0 +

Add comment

Please sign in to leave a comment.