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...
  • slorin's avatar
    2 years ago

    Hi, LucTP 

     

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

    Stéphane 

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