Bobby Heid
bheid at appdevgrp.com
Wed Jul 9 10:28:03 CDT 2003
i=instr(string,"--") strOne=Left$(string, i - 1)) strTwo=Right$(string, Len(str2) - i - 1) HTH, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte Sent: Wednesday, July 09, 2003 10:58 AM To: accessd at databaseadvisors.com Subject: [AccessD] Parsing data Hello All, In A97 I need to seperate some data into 2 fields...ex: "test--data1" test2--data" How do I pull left and right of '--'? Thanks, Mark A. Matte _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com