I have a inherited a fox pro 9.0 database where the developer instead of creating Contact Last Name and Contact First Name fields they created only Contact Name.
Is there function that I can use where it searches for the blank space in order to split the contact name? Can I then add a replace code to copy the information to the 2 new fields I just created?
I can do this with other programs but I can't figure out how to this in fox pro. Thanks!
Is there function that I can use where it searches for the blank space in order to split the contact name? Can I then add a replace code to copy the information to the 2 new fields I just created?
I can do this with other programs but I can't figure out how to this in fox pro. Thanks!