[AccessD] text between ( )

David McAfee davidmcafee at gmail.com
Wed Dec 9 11:58:37 CST 2009


If this looks good:
SELECT Concl, Mid([Concl],InStr(1,[Concl],"(")+1,InStr(InStr(1,[Concl],"("),[Concl],")")-2)
AS Expr1
FROM YourTable
WHERE (((Concl) Like "*(*)*"));

you can do it like this:
UPDATE YourTable SET YourTable.fldSelection =
Mid([Concl],InStr(1,[Concl],"(")+1,InStr(InStr(1,[Concl],"("),[Concl],")")-2)
WHERE (((YourTable.Concl) Like "*(*)*"));



On Wed, Dec 9, 2009 at 8:13 AM, Pedro Janssen <pedro at plex.nl> wrote:
> Dear Group,
>
> is it possible to filter out text between (  ) in a field [Concl] and place only the text between (  ) in a new field [fldSelection], with a query.
>
> Thanks
>
> Pedro
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list