I have imported name lists (about 200 000 names ) from several Excel DBF-files. For some reason the table 'Name' column were mixed up, all the names looked like this
' sometext(AndersSvensson)' without spaces. The names are only First and Last name.
I have managed (by SQL) to extract the name but how to insert a space before the last Ucase letter as Anders Svensson.
I can't figure out how to split the name into First name and Last name or insert a space.
Asc (string) only points at the first Ucase letter. I cant find a solution to highlight the last Ucase letter.
Any help would be appriciated. Can it be done through SQL?
Looking forward to the reply.
' sometext(AndersSvensson)' without spaces. The names are only First and Last name.
I have managed (by SQL) to extract the name but how to insert a space before the last Ucase letter as Anders Svensson.
I can't figure out how to split the name into First name and Last name or insert a space.
Asc (string) only points at the first Ucase letter. I cant find a solution to highlight the last Ucase letter.
Any help would be appriciated. Can it be done through SQL?
Looking forward to the reply.