[AccessD] Parsing data

Use Instr function to find the position of the '--' and then pull everything
to the left of that position minus 1 and everything to the right of that
position plus 2.

intPos = Instr(1, "test--data1", "--")
strLeft = Left("test--data1", intPos - 1)
strRight = Right("test--data1", Len("test--data1") - intPos + 2)

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----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