ajnhlr Posted June 2, 2006 Posted June 2, 2006 This seems elementary, but I can't find anything about it and have tried every combination I can think of. I've got a field I want to trim, perform a Let function in and have text "Wrong Format" in the field if the user doesn't enter the correct info for the Let function. In what order should these steps be performed? I would think in as I've listed them, but can't get it to work. Should there be a Remove Text or Reformat Text in there somewhere? Is there a guide somewhere that shows the order functions should be performed? Thanks.
Ender Posted June 2, 2006 Posted June 2, 2006 The order of functions depends on the situation. In some cases it doesn't matter, in others changing the order gives different results. If you can show the possible combinations of inputs along with what the desired results should be, we may be able to give you a specific answer.
ajnhlr Posted June 2, 2006 Author Posted June 2, 2006 This is the shortest example I have. The Let function produces 5 digits if that's all that's entered and 9 if all 9 are entered. I'm trying to make sure the Wrong Format is brought up if the user happens to enter more than 5 but less than 9. Thanks, Ender. TrimAll( Work Zip Code ; 1 ; 0 ) /*remove all extra spaces*/ _________________________________________________________________ Let ( [tempZip = Filter ( Work Zip Code ; "0123456789" ) ]; Left ( Work Zip Code ; 5 ) & If ( Length ( tempZip ) = 9 ; "-" & Right ( tempZip ; 4 ) ; "" ) ) _________________________________________________________________ TextColor("Wrong Format"; RGB(250 ; 0 ; 0)
Recommended Posts
This topic is 6811 days old. Please don't post here. Open a new topic instead.
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