RE: [AccessDevelopers] how to split this character?

[Tom Oakes]

You can use the Split function: 
 
'***** code start *****'
 
Dim varItem As Variant
 
For Each varItem In Split("abcde|ajhui|reiek", 
"|")
    Debug.Print varItem '<-- do whatever 
you need to with the individual values
Next
 
'***** code end*****'
 

Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.968.6946 
(C) 713.583.7091 (F) 




From: AccessDevelopers@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of verly 
yuliSent: Wednesday, July 06, 2005 9:51 PMTo: 
AccessDevelopers@yahoogroups.com; 
accessvbacentral@yahoogroups.comSubject: [AccessDevelopers] how to 
split this character?
hello alli have a example 
textabcde|ajhiu|reiekhow to split this text to row?thank you for 
all supportregards warmestverly 
yuli            
____________________________________________________Sell on Yahoo! 
Auctions – no fees. Bid on great items.  http://auctions.yahoo.com/Please 
zip all files prior to uploading to Files section. 



Please zip all files prior to uploading to Files section.



  
  





  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.