couple things your could do
yes you can split the split - assume you know how to do that
your field that returned United States) i will call split 1
or you can use left( [split1],(len[split 1]-1))
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I never though to split the split.. hah... oh my. Thank you for the advice.