AnsweredAssumed Answered

Extracting word(s) after a specific word

Question asked by celineladoire on Sep 25, 2018
Latest reply on Sep 25, 2018 by beverly


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?

Outcomes