[AccessD] Parsing data

intPosition = InStr(1,strTheString,"--")
strRight = Mid(strTheSTring,intPosition+2)
strLeft = Left(strTeString,intPosition-1)

Lembit Soobik

----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, July 09, 2003 4:57 PM
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
>