Re: Extract data from a field using a delimiter character
- From: "kingston via AccessMonster.com" <u27511@uwe>
- Date: Wed, 11 Oct 2006 19:23:52 GMT
Mid(Mid(String, Instr(String,"(")+1),Instr(Mid(String, Instr(String,"(")+1),")
")-1)
I think all the parentheses are in there correctly. Anyway, you get the idea.
HTH.
bdmsfan wrote:
I have a column with the following values
SCL (LP Steam Condensate)etc...
WF (Fire Water)
P (Process Piping)
I need to extract only the characters inside the parenthesis (i.e.LP Steam
Condensate or Fire Water or Process Piping). I thought using the Left
Function but since the length is variable I am not sure how to set it so it
uses the parenthesis as delimiter. Thanks in advance.
Bruno
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200610/1
.
- Prev by Date: Re: Parameter Query prompt - How to let user select all
- Next by Date: Re: How do I calculate times over multiple records?
- Previous by thread: Re: Extract data from a field using a delimiter character
- Next by thread: Re: Extract Data from a Field using a delimiter character
- Index(es):
