I have a data field that could contain 3 different numbers (8 characters each) and I need them displayed in three different text fields. Some times there is only 1 number, sometimes 2 and sometimes 3. They are all in the same data field with a space in between each number.
The first text field is easy - keep the first 8 characters
The last test field is easy - Keep the last 8 characters
The middle on number is more difficult. How can I discard the first 8 characters on the left and the right?
If there is only 2 numbers, it will display properly. If there are 3 numbers how can I create an if statement to display the number in the middle?
Please sign in to leave a comment.