Case Suggestion needed
I have part of my solution figured out but stumbling on the balance. Listed below are examples of input information I am trying to separate. The first part works extracting from my "Country Field" using this
GetValue ( Substitute ( Country ; "." ; ¶ ) ; 2 )
ex. 1 Fr. Cote du Nuit gives me Cote du Nuit
However when I have a single word with out the "." nothing shows up.
ex 2. Mosel
I believe this is a case issue just haven't been able to dial in.
Thanks for direction!