this is the scenario, on one of my reports there is a specific field that users enter a 16 digit number into, but most of the time it is the 16 digit plus additional unnecessary information consisting of alphanumeric and special characters, i have no control over the field and the 16 digit entered is not always in the same format, sometimes it is entered with a space and sometimes without a space, i need to design a rule that only extracts the 16 digit number from the rest of the garbage, what can i do?
Here are some assumptions based on your note:
You could do this simply by going through the string character by character and if the character is a digit ( 0 thourgh 9) then extract it. Do this until you've got 16 of them.
Adrian
brought to you by enabling practitioners & organizations to achieve their goals using: