Parse Full Name into First and Last Name attributes

[Jhstephenson]

I have a Full Name attribute that I want to split into FirstName and LastName attributes. I thought I could use the WORDS_FROM_LEFT or WORDS_FROM_RIGHT functions to do this. But apparently they only work with Derby.

So, I am wondering what is the easiest way to do this in Aware?

[rbross]

Hi Jim,

There is a way to do this but I forget the function. I did something similar when creating a numbers to words program.
If I remember right there is a function in Aware that will find the first space to split up two words in one attribute.

I will look for it and get back to you.

[intra]

Maybe something along the lines of this.

FullString = John Smith

Firstname = SUBSTRING(FullString, 0,INDEX_OF(' ',FullString))
Surname = SUBSTRING(FullString, INDEX_OF(' ',FullString),LENGTH(FullString))

[ACDC]

But apparently they only work with Derby.

I use this extensively in MySql

[Jhstephenson]

But apparently they only work with Derby.

I use this extensively in MySql

That's interesting. This is what it says in Appendix B of the User Guide:

4. The following functions are supported only in Cloudscape/Derby database:
- WORD_NUMBER
- WORDS_FROM_LEFT
- WORDS_FROM_RIGHT

[Jhstephenson]

Maybe something along the lines of this.

FullString = John Smith

Firstname = SUBSTRING(FullString, 0,INDEX_OF(' ',FullString))
Surname = SUBSTRING(FullString, INDEX_OF(' ',FullString),LENGTH(FullString))

Thanks, that works.

[Jhstephenson]

But apparently they only work with Derby.

I use this extensively in MySql

That's interesting. This is what it says in Appendix B of the User Guide:

4. The following functions are supported only in Cloudscape/Derby database:
- WORD_NUMBER
- WORDS_FROM_LEFT
- WORDS_FROM_RIGHT

I also tried this and it works too. Apparently we aren't supposed to believe the documentation.