Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim to specified character
Message
From
19/05/2004 13:01:00
Michael Vassallo
Efi, Inc.
Pittsburgh, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Trim to specified character
Miscellaneous
Thread ID:
00905326
Message ID:
00905330
Views:
13
This message has been marked as the solution to the initial question of the thread.
You can use the AT() function to find the position of the ",".
nPos = AT(",",field)
nLen = LEN(field)
IF nPos > 0 && Found
   sLastName = SUBSTR(field,1,nPos - 1)
   sFirstName = SUBSTR(field,nPos + 1, nLen)
ENDIF
Previous
Reply
Map
View

Click here to load this message in the networking platform