Currently, I have a formula to execute some number stripping for a column. When the user uses a card swipe, it outputs something like: ;502780133=0444?
The formula strips the semicolon and removes everything from the equal sign and on. Also, if a number isn't entered, it will display the error message "Enter SUID on Package Pickup"
=IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1))
I want to keep the error message intact, but I want the number stripping to occur only if a semicolon is found. This will help prevent errors when users manually enter the ID numbers.
Is this possible?
0 commentaires:
Enregistrer un commentaire