I have a field with voyage_names. For example:
New York to San Francisco
Paris to Marseille
I would like to extract the second location after the "to" using a calculation field.
I've managed to extract the starting point using
Left ( voyage_name ; Position ( voyage_name ; " to " ; 1 ; 1 ) - 1 )
But I can't seem to make it work using Right () to get the end point. It keeps cutting up the words.
Would you be able to help? Or at least point me in the right direction?