Want to have option to trim Leading Spaces

vanram · January 25, 2012 11:17AM

I just had a data compare that i needed to trim leading spaces as well as trailing spaces. Please could you add this option.

chriskelly · January 25, 2012 12:37PM

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

David Atkinson · January 25, 2012 5:14PM

Could you create a view that does the trimming and sync that back to the original table?

David Atkinson
Red Gate

vanram · January 25, 2012 6:48PM

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

David Atkinson · January 25, 2012 7:37PM

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?

vanram · January 25, 2012 9:06PM

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.

David Atkinson · January 26, 2012 4:03AM

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

vanram · January 26, 2012 9:39PM

Fair enough, thx

Want to have option to trim Leading Spaces

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk