>Hi all,
>
>How do a parse a field that contains two data elements together (i.e. "MA BOSTON ") into two separate fields with each individual data element for all the records in a table? In VFP, this would be simple:
>
>REPLACE ALL orgcity WITH SUBSTR(orgcitysta,AT(" ",orgcitysta) + 1)
>
>In Access 97, however, I believe I have to write a module which parses the string (using MID$ function??) and call it from an update query.
>
>Any suggestions?
>
>Thanks for your help!
>
>-JT
Do you use VB5 or VB6?
If you use VB6, you now have the Replace function.
If you use VB5, you have to play with INSTR and MID to replace characters.
Tell me if you use VB5 and I will give you a code snippet that does this.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com