SBpro Index fields
04-Jun-93 18:23:17
Sb: #58186-SBpro Index fields
Fm: Clark Williams 76237,746
To: Christian Busse 100121,1360
Christian,
How about:
TRIM$(UCASE$(Lastname.CD)) LEFT$(", "+FirstName.CD,
LEN(FirstName.CD)+2*ABS(LEN(FirstName.CD)>0))
If your file had the following entries:
Rec 1)LastName.CD ==> Busse
FirstName.CD ==> Christian
Rec 2)LastName.CD ==> Software Industry & General Hardware
FirstName.CD ==> <empty>
Then the output would be:
Busse, Christian
Software Industry & General Hardware
Hope this helps,
Clark -|-
Williams –O-o-O– Via George