Look up the "Instr", "Left", "Right" and "Mid" functions in help.
Neil Squires -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of verly yuli Sent: Wednesday, July 06, 2005 10:51 PM To: AccessDevelopers@yahoogroups.com; accessvbacentral@yahoogroups.com Subject: [AccessDevelopers] how to split this character? hello all i have a example text abcde|ajhiu|reiek how to split this text to row? thank you for all support regards warmest verly 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. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
