Still… HELP!!!
Tried it with:
UCASE$(LastName.CD) + LEN(FirstName.CD) > 0 ? ", " + UCASE$(FirstName.CD)
: "" + " " + UCASE$(NameSuffix.CD)…
and keep getting "Datatype mismatch" error when trying to save it. If I
put round brackets around the ternary operation I get a "Closing Bracket
missing" error when trying to save it. Seems to me it just doesn't work in
a field calculation definition…
Anyone else got any solution???
Chris from Germany on Autopilot
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