Forum Discussion

LucTP's avatar
LucTP
Icon for Helper I rankHelper I
2 years ago
Solved

How to get contry name in address?

Hi everyone  I want get contry name from address   (JUNGANG BLDG, NAGWON-DONG) 4F-503, 11GIL 34, DONHWAMUNRO, JONGNOGU, SEOUL, KOREA, KR 24 EASTER INDUSTRIAL PARK, FERRY LANE SOUTH, R...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Another alternative formula in a custom column would be (Replace Data with your column name)

List.LastN(Text.Split([Data], ", "),2){0}