This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Extract text - country from address

Posted on 03-05-2023 12:12 AM
David_H1
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hi,

How could I extract text - country from address field?

221B Baker St, London NW1 6XE, UK

It should return value after last comma, and remove/trim the space value before UK.

I am struggling with Extract function here.

Thank you.

Solved Solved
0 3 719
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Please try 

INDEX( SPLIT([Address], ", "), COUNT( SPLIT([Address], ", ")))

View solution in original post

Jump to Solution
3 REPLIES 3
Top Labels in this Space