abhas (2/4/2015)
Thanks Phil for your suggestion. I am able to split lastName as Pawar by using below code of stuff.SUBSTRING(Name,1,FINDSTRING(Name,",",1) - 1)
but not able to identify FirstName as Ramesh. M trying on that
Thanks
Abhas.
Good stuff. To get Ramesh, you need to do something like this:
1) Find the position of the comma.
2) Find the position of the space, starting searching from the position of the (comma + 1).
3) Extract the string between (1) + 1 and (2)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.