|
Posted by whitej77777 on 06/12/07 19:42
I am trying to write a user defined function that will allow me to
strip off the last carriage return and line feed from a text field.
We have address fields stored in a text field for our ERP system and
some of them have an extra carriage return and line feed at the end of
them. This causes havoc when we sync between our ERP system and CRM
system. If anyone knows a way to solve this problem the help would be
appreciated.
Examples:
Existing Text field with CR:
1234 Blah Street<CR>
Suite 2345<CR>
Corrected Text field:
1234 Blah Street<CR>
Suitr 2345
Navigation:
[Reply to this message]
|