Removing words and spaces using DTS

• Chris Horsley

  Valued Member

  Points: 65

  More actions

  September 7, 2004 at 5:30 pm

  #76184

  I have a table of addresses I need to import each month and under the

  'County' Column the word County or Borough follows each county name. Ex

  'Baltimore County', 'Washington County', 'Davis Borough' etc.

  Using DTS is there a way to remove the space and County(Borough) following

  each county name?  I've tried using the trim feature but that only seems the

  Trim the White Space.

  Thanks for any help you can offer.

• ewilson10

  SSCarpal Tunnel

  Points: 4255

  More actions

  September 7, 2004 at 5:40 pm

  #522037

  If you're using a transform data task you could always hit the source SQL with something like:

  RTRIM(REPLACE(REPLACE(County,'County',''),'Borough','')) AS County

  
  
  Everett Wilson
  ewilson10@yahoo.com

• Chris Horsley

  Valued Member

  Points: 65

  More actions

  September 8, 2004 at 6:01 pm

  #522211

  I used the following code successfully:

   

  UPDATE TableName

  SET County = (REPLACE(REPLACE(County,' County',''),' Borough',''))

  GO