Newbies smeshy123 Posted July 31, 2007 Newbies Posted July 31, 2007 I'm trying to get rid of the first letter in a certain field, but only if that letter is a -. I have 4000 entries so I can't do it by hand. Anyone know the kind of calculation I could write to do this? Thanks, Smeshy
comment Posted July 31, 2007 Posted July 31, 2007 Try: Right ( Yourfield ; Length ( Yourfield ) - ( Left ( Yourfield ; 1 ) = "-" ) )
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now