Want to have option to trim Leading Spaces

• 
  Thank you for your suggestion. I have created a Feature Request (SDC-1303) for our development team to take in to consideration.

  chriskelly January 25, 2012 12:37

  - 0 +
• 
  Could you create a view that does the trimming and sync that back to the original table?
  
  David Atkinson
  Red Gate

  David Atkinson January 25, 2012 17:14

  - 0 +
• 
  I agree that should work. This should have limited performance affect but would be another object in the DB to maintain...

  vanram January 25, 2012 18:48

  - 0 +
• 
  So this is a regular use case rather than a one off? Can I ask why you are ending up with unwanted spaces in your fields?

  David Atkinson January 25, 2012 19:37

  - 0 +
• 
  I am not sure how frequent this issue will be.
  
  This comes about due to the source being a field coming from our ERP system (AS400) that is a concatenated string, we do now know how the spaces at the begining of this field come to be included.

  vanram January 25, 2012 21:06

  - 0 +
• 
  We have had customers who have trailing spaces in their data (and therefore we have an option in the tool to trim these), but I think you're the first to have leading spaces. I guess my advice would be to try to fix the problem at the source, or to use the View suggestion if it's an infrequent occurrence.
  
  If we get further requests for this, it's something we would definitely consider adding as an option.
  
  David

  David Atkinson January 26, 2012 04:03

  - 0 +
• 
  Fair enough, thx

  vanram January 26, 2012 21:39

  - 0 +

Add comment

Please sign in to leave a comment.