VBA function (separating name from first name)

[Czoug]

Hi
I have one column of first names combined with names(surenames) like:
(not real names

David Fare
Felix Genth
A.F. Berth
Bern Nelroy
V.N. Halu
etc.

I would like to sort this column to get surenames from A-Z, I was searching about a VBA function which would take from right side signs starting from first sign and ending by first space, but I can't find such one.
Thanks for help

[alansidman]

How about doing some manipulation in a query? Take a look at this video to get you started in the right direction.

http://www.datapigtechnologies.com/f...anipulate.html

Once you have looked at this, then you can apply the concept to creating new fields with first and last names that can be sorted any way you wish. Quick and easy and does not require VBA.

Alan

[Czoug]

Didn't help. My last names are not constant(number of signs), his were. I need a function that take back not "x" letters, but in ranges as I sad.

[alansidman]

Why don't you post your data base with some sample data in it so that we can play with it. I believe that using the Len function and the Mid function you can accomplish data manipulation of your information. This is something I have done in the past.

Here is a solution that should work for you. In the example, change the underscore "_" to a space " " in your case.

http://www.techonthenet.com/access/questions/parse.php

Alan

[orange]

You may be able to adapt this query. But it will not handle surnames like
J.P. St. Pierre
Claude Van Dam
David del Rio

SELECT PersonNames.pName
, Mid([pName],(InStrRev(Trim([PersonNames]![pName])," ")+1)) AS pSurname
FROM PersonNames;

where pName is the full text field to be parsed
PersonNames is the name of the Table

[Czoug]

I have it. Very simple:
split([pole],' ')(0) - first element
split([pole],' ')(1) - second element