The problem is that whoever was responsible for creating this data source was incompetent.
You can make assumptions and try to extract this, but the rules are extensive, I used to clean lists for a living...
The simple means is to use:
first name
Left({table.nakme},instr(" ",{table,name})-1)
last name
mid({table.nakme},instr(" ",{table,name})+1)
But there are so many gotchas in names that you'll be correcting the rules forevermore...
The best bet is to correct the data source, if you find it too tedious, intersperse the boredom with firing red hot reminders of your displeasure at the database designer using a nailgun.
There used to be some 3rd party products to help with this, perhaps one of those might help clean the list.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.