String Manipulation

[martin250]

Hi, I'm trying to take a surname string with a hyphen in it, and make both names before and after the hyphen PROPER case.
m.surname = "SALLY-ANNE"
I need it to print out... Sally-Anne
I have tried for awhile without any success. Please can you help.

Thanks in Advance.

Mart

 

[fitedgar]

hey mart, Try:
m.surname = "SALLY-ANNE"

lc_last = SUBSTR(m.surname,RAT("-",m.surname)+1)
lc_first = LEFT(m.surname, RAT("-",m.surname) - 1)

lc_name = PROPER(lc_first) + "-" + proper(lc_last)

Regards
EMC

 

[TheRambler]

Mart,

This thread184-551143 is from the Visual FoxPro forum, but you may find it helpful too.

 

[martin250]

Thanks EMC, thats exactly what I was after.
It works great TY

Thanks also mlv1055 for the info on that thread.

Mart