Changing name format displayed in Column

[rsdhavle]

We want to change name format displayed in column. Lets say the name is displayed as Pratap, Ganesh..Mishra, Ritesh. I want to dsiplay it as Ganesh Pratap, Ritesh Mishra etc.. How can it be done? Which function can be used?

[kaushiknsolanki]

Hi,

There is no function which can directly do this for you, but you will need to use some of the string functions to do this.

Load SubField(Name,',',2) & ' ' & SubField(Name,',',1) as New_Name,Name inline [

Name

"ABC, AAA"

"PQR, PPP"

];

Regards,

Kaushik Solanki