Lars,

Sollte so funktioneren

vorname = Left(name, (instr(name, ",")-1))
nachname = Right(name, ((len(name))-(InStrRev(name, ","))))

Nur f�r Lars: Ah �brigens chasch necher gschwing abecho weg em Backup-Vortrag

-----Urspr�ngliche Nachricht-----
Von: Schnyder, Lars 
Gesendet: Montag, 25. November 2002 13:05
An: AspGerman Kaffeehaus
Betreff: [aspdecoffeehouse] Trim


Hallo Liste, kleine VB Frage

Wie krieg ich aus: 

"Lars, Schnyder" 
"Lars" und "Schnyder"

..das heisst, ich will den Wert einer Variable (immer VORNAME + ", " +
NACHNAME) den Vornamen und den Nachnamen raustrimmen und in ne andere Variable 
schreiben? Ich kenn nur Leerzeichen oder ne bestimmte Anzahl trimmen, aber das geht ja 
hier nicht.

THX lars
************************************************************************************
This e-mail message is intended only for the addressee(s) and contains
information which may be confidential. If you are not the intended
recipient please do not read, save, forward, disclose or copy the contents
of this e-mail. If this e-mail has been sent to you in error, please delete this 
e-mail and any copies or links to this e-mail completely and immediately
from your system. We also like to inform you that communication via e-mail
over the Internet is insecure because third parties may have the possibility
to access and manipulate e-mails.

Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
The Swatch Group Ltd.
************************************************************************************

| [aspdecoffeehouse] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdecoffeehouse/ = Listenarchiv
| Sie k�nnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdecoffeehouse.asp

Antwort per Email an