Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stripping
Message
From
09/04/2008 11:32:50
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01309362
Message ID:
01309378
Views:
9
So, run this for each word in the name instead of the whole name? Yeah, but that assumes that prefix is always in the beginning and suffix is always at the end. It's not always the case. "Proffler, Mr., Droopy" would not work. Maybe I'll just drop "Master" from the list.

>What if somebodys name is 'Master'? You should parse full name first.
>
>>This isn't quite right. It replaces things like portions of tcName that I don't want it to. It strips the "Mr" but also the "Dr" and "Prof" portions. I think I have to do something more with the GetWordNum, but can't quite get it to work. Any help (yours, not the Foxpro) is appreciated.
>>
>>
>>tcName = "Mr Droopy Proffler"
>>
>>* Strip common name prefixes.
>>m.ReplaceWith = ''
>>m.PrefixSearchString = [ MR MRS MS MISS DR PROF SIR MASTER REV REVERAND ETC ]
>>FOR x = 1 TO GETWORDCOUNT( m.PrefixSearchString )
>>	m.LookFor = ALLTRIM(UPPER(GETWORDNUM(m.PrefixSearchString,x)))
>>	tcName = CHRTRAN(UPPER(tcName),m.LookFor,m.ReplaceWith)
>>ENDFOR
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform