Name display

[#1]

I have a column called Name

ex:Name

    Rai,Sam

where Sam is first name and Rai is last name

so I only want to display last name.How can I do that ?

[Digvijay_Singh]

Use subfield if comma is the delimiter -

Subfiled(Name,',',1) as Lastname

[sunny_talwar · Accepted solution]

My bad

[Gabriel]

Hi,

You can split the field in the script

LOAD

NAME,

Subfield(NAME,','1)     AS FirstName,

Subfield(NAME,',',2)     AS LastName

,....

From Source;

Then in UI you can use LastName field as you want.

[#5]

Try Subfield(name,','1)  AS FirstName

[#6]

subfield(name,',',1) as lastname.

use it may help

[#7]

Thank you very much.