i have a field called a1,b2,c3 but i want in front end like a,b,c?

[#1]

i have a fields called a1,b2,c3  but i want in front end like  a,b,c or  1,2,3?  by using a some function ? what is the function and how to change ?

[#2]

you can use if condition like:

if(field='a1',1,if(field='a2',2,if(field='a3',3)))

or

if(field='a1','a',if(field='b1','b',if(field='c1','c')))

[#3]

hi

try this

Rename field a1 to a;

Rename field b1 to b;

Rename field c1 to c;

[#4]

Hi

You can use the left function like in excel

Regards

Padma

[Siva_Sankar]

Hi Manoj,

Try using rename function and mapping table. Find the attachment for example.