Search the web
Sign In
New User? Sign Up
pendragon-forms · Pendragon Forms
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Trim function   Message List  
Reply | Forward Message #2856 of 2883 |
Re: Trim function

I tried that, but unfortunately the value may have varying amount of
spaces at the end. It's padded to 15 characters. So for example a
value of 12345 would have 10 spaces but 1234567890 would have 5
spaces. I just want to trim all ending spaces.

Is there a way to loop through the characters starting at the end and
stop when it encounters a valid value?

Dawn

--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert
<dhwert@...> wrote:
>
> You should be able to use the "Left" or "Right" functions to
extract the leftmost "x" characters or the rightmost "x" characters
from any particular value. Or the "Mid" function to extract a
section in the middle. Check the Scripting Reference for more
details as needed.
>
> Dave
>
>
>
>
>
> ----- Original Message ----
> From: Dawn Anastasi <danastasi@...>
> To: pendragon-forms@yahoogroups.com
> Sent: Wednesday, October 1, 2008 2:54:31 PM
> Subject: [pendragon-forms] Trim function
>
>
> Is there a "trim" function for stripping out leading and/or
trailing
> spaces from a field in a calculate event?
>
> Dawn
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





Wed Nov 26, 2008 4:33 am

dawn_anastasi
Offline Offline
Send Email Send Email

Forward
Message #2856 of 2883 |
Expand Messages Author Sort by Date

Is there a "trim" function for stripping out leading and/or trailing spaces from a field in a calculate event? Dawn...
Dawn Anastasi
dawn_anastasi
Offline Send Email
Oct 1, 2008
10:06 pm

You should be able to use the "Left" or "Right" functions to extract the leftmost "x" characters or the rightmost "x" characters from any particular value. Or...
Dave Hockman-Wert
dhwert
Online Now Send Email
Oct 2, 2008
2:43 pm

I tried that, but unfortunately the value may have varying amount of spaces at the end. It's padded to 15 characters. So for example a value of 12345 would...
Dawn Anastasi
dawn_anastasi
Offline Send Email
Nov 26, 2008
3:43 pm

Oh, I see what you mean now. I don't think you can do this within Pendragon, but you can in MS Access. So the easiest thing to do would be to fix this issue...
Dave Hockman-Wert
dhwert
Online Now Send Email
Dec 2, 2008
3:42 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help