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.

Thanks

No screenshot attached, but what you describe can be done in several ways:

Let ( y = yourField ; Replace ( y ; 1 ; Position ( y ; "-" ; 1 ; 1 ) ; "" ) ) , or

Let ( y = yourField ; Middle ( y ; Position ( y ; "-" ; 1 ; 1 ) + 1 ; Length ( y ) ) ) , or

Let ( y = yourField ; Right ( y ; Length ( y ) - Position ( y ; "-" ; 1 ; 1 ) ) ) , or

GetValue ( Substitute ( yourField ; "-" ; ¶ ) ; 2 )