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, RAINHAM RM13 9BP, UK, ZZ
4TH FL. NO. 10, LANE 88, HUANGSI ST, SHIHLIN DISTRICT, TAIPEI 11157, TAIPEI, TW
55 VANSCO ROAD, TORONTO, ONTARIO, M8Z 5Z8, CANADA, ZZ

 

result 

(JUNGANG BLDG, NAGWON-DONG) 4F-503, 11GIL 34, DONHWAMUNRO, JONGNOGU, SEOUL, KOREA, KRKOREA
24 EASTER INDUSTRIAL PARK, FERRY LANE SOUTH, RAINHAM RM13 9BP, UK, ZZUK
4TH FL. NO. 10, LANE 88, HUANGSI ST, SHIHLIN DISTRICT, TAIPEI 11157, TAIPEI, TWTAIPEI
55 VANSCO ROAD, TORONTO, ONTARIO, M8Z 5Z8, CANADA, ZZCANADA

 

Thanks & Regards,

LucTP

Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi, LucTP 

     

    Text.BetweenDelimiters([YourColumn], ",", ",", {1, RelativePosition.FromEnd}, 0)

    Stéphane 

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    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}

     

2 Replies

  • slorin's avatar
    slorin
    Icon for Super User rankSuper User
    2 years ago

    Hi, LucTP 

     

    Text.BetweenDelimiters([YourColumn], ",", ",", {1, RelativePosition.FromEnd}, 0)

    Stéphane 

  • 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}