I'm writing a script that is to find and copy the number value found to another field. I'm using the Right and Position Functions get the number value.
I'm testing each section of the script in the Data Viewer and I've run into a problem and need help with the Position function. The Position function is used to find a "-" Dash then the Right function is suppose to get all numbers to the right of the dash, which will then be copied into another field.
The script works, it finds the Dash but it's doesn't returning the values in the order that I'm looking for. I've been playing around with the Position function parameters (Start and Occurrence) and this is where I looking for help.
This a screen shoot of my Data Viewer attached.