this is mahesh i have question pls give the answer

[Anonymous]

i have  date  like

                          name

             first name   last name

             rohit             sharma

             suresh           raina

             virat               kohil

like  these when  I am loading   it in  list box  in UI  it  displays both first name  and last name it considering as  field  as name  but in scenario is  i need to separate  first name and last name  how is it possible ?  i  need take this as  two different fields like  first name is one filed and last  filed

[sunny_talwar]

I would try to separate them in the script itself (if possible)

SubField(Name, ' ', 1) as [First Name],

SubField(Name, ' ', 2) as [Last Name]

If this is not possible, I would do it using list box expression:

SubField(Name, ' ', 1) for First Name

SubField(Name, ' ', 1) for Last Name

Above assumes that your names are First_Name Last_Name with a space between them. If this is not true, you will have to let us know how they look.

[Anonymous]

hii sunny,

i have query

If this is not possible, I would do it using list box expression:

SubField(Name, ' ', 1) for First Name

SubField(Name, ' ', 1) for Last Name  

why u have  give  1  for both  fist name  and last name

[sathishkumar_go]

HI Mahesh,

How can you distinguish the First name and last name.

For all the case's you have space between first name & name then use subfield function

SubField(Name, '  ', 1) as First_Name,

SubField(Name, '  ', 2) as Last_Name

-Sathish