Can i auto Remove the white spaces from starting and end of all the string fields which is in my instance.

[VIKAS MISHRA]

Can we achive this globally, like i do not want to use trim() method for all the string fields one by another, is this possible that i make some changes in the instanse and from that time all the string fields in my system will have the capablity to remove the white spaces by itself.

[johnfeist]

Hi Vikas,

As far as I know, there is no way to accomplish this globally.  Applying something like that globally can have any number of unexpected side effects since you are not aware of all the string fields in your instance and how they are used.  The best way to manage such things ongoing is via business rules where, yes, you will need to use trim().  To get started, you will need to run scripts that will take care of the existing data.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster