Replace

[ptl14495]

Hi,

When doing this formulad

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace("Communication Type",
'0','Vazio'),
'1','Fax'),
'2','E-Mail 1: Interactive'),
'3','GPRS'),
'4','HTTP 1:Interactive'),
'5','Data GSM'),
'6','NetCare'),
'7','E-Mail 2: One way'),
'8','HTTP 2: One way'),
'9','PF'),
'10','SA'),
'11','CD')

the final result has a flaw with 0, 1, 10 and 11

meanning

0 = Vazio

1 = Fax

10 =FaxVazio

11=FaxFax

how can i correct this?

thank you

FR

[Anil_Babu_Samineni]

Perhaps this

Pick(match("Communication Type", 0,1,2,3,4,5,6,7,8,9,10,11),
'vazio','Fax', 'E-Mail 1: Interactive', ..., 'CD')

[ptl14495 · Accepted solution]

Top! It worked!