String Manipulation

[zwyne]

Hello everyone,PFA,

Hello everyone,PFA,

I would like create a create another column called Country from the column Assessment. My expected result is 

Assessment	Country
AGLB - NBC Tanzania - CA	NBC Tanzania
AGLB - Ghana - CA	Ghana
AGLB - Kenya - CA	Kenya
AGLB - Mauritius - CA	Mauritius
AGLB - Tanzania - CA	Tanzania

[m_woolf]

=subfield(Assessment,' - ',2) as Country

[j_puri_6601]

=subfield(subfield(Assessment,' - ',2),' - ',1) as Country