Mark, LTRIM removes leading spaces (specifically space bars) and not leading carriage returns. To remove leading carriage returns, you might need to write a stored procedure in your DB to do it for that specific field and then called that SP.
Cheers Joe ** ________________________________ From: "Brittain, Mark" <[email protected]> To: [email protected] Sent: Thu, March 18, 2010 12:03:57 PM Subject: LTRIM Question Hi All, I want to remove the leading space from a field on save and thought LTRIM would do the trick but it is not. If the entry in the field is like this “ Here is my update” I want it to be this “Here is my update” I am using a set field “Update LTRIM($Update$)” after the information is pushed to a another form. I have also tried it as part of the push. Any suggestions? Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite [email protected] (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
