Convert Number to Text

[bharatkishore]

Hi All,

I have a field in that i have numbers like 1704,1705.. etc.

Now  i need to get names instead of numbers.

For e.g. 1704 should be Germany.

I have written if(Match(field,'1704','Germany'),Field).

But this is expression is not working and getting number only.

Can you please tell me how to achieve this.

Thanks,

Bharat

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

if(Match(field,'1704'),'Germany',Field)

Or

Pick(Match(field,'1704','1705'), 'Germany', 'India').

[bharatkishore]

Thank you so slight mistake(brace) in my expression. My bad and thanks a lot..