<div>
Left(YourString, Instr(1,YourString,Chr(34)<wbr />)-1)<br />
<br />
try that ...<br />
<br />
mx
</div>


Left(YourString, Instr(1,YourString,Chr(34))-1)

try that ...

mx

<div>
where is this substring coming from?<br />
<br />

</div>


<div>
You could just<br />
<br />
#include &lt;string&gt;<br />
using namespace std;<br />
<br />
int pos1,pos2;<br />
<br />
string str = // your string<br />
<br />
pos1 = str.find('\&quot;');<br />
pos1 = str.find('\&quot;', pos1 + 1);<br />
<br />
string result = str.substr(pos1 + 1, pos 2 - pos1 - 1);
</div>


You could just

#include <string>
using namespace std;

int pos1,pos2;

string str = // your string

pos1 = str.find('\"');
pos1 = str.find('\"', pos1 + 1);

string result = str.substr(pos1 + 1, pos 2 - pos1 - 1);

<div>
Access<br />
C++<br />
Visual Basic<br />
<br />
Which one is it ?
</div>


Access
C++
Visual Basic

Which one is it ?

<div>
I actually had to go w/ this.<br />
Mid$([val], 1, InStr(2, [val], &quot;&quot;&quot;&quot;) - 1)<br />
&nbsp;but close enough, thankx!
</div>


I actually had to go w/ this.
Mid$([val], 1, InStr(2, [val], """") - 1)
 but close enough, thankx!

<div>
<div class="content wysiwyg-content">
I'm trying to use the mid and instr functions to pull a substring from a string like this example:<br />
<br />
&quot;JTTTT0645T383&quot;TUCKER, JAMmES&quot;9999999999999999999<wbr />999999&quot;&quot;6/<wbr />27/2037&quot;&quot;&quot;<wbr />1/1/1900&quot;&quot;<wbr /><br />
<br />
I would like to receive this value:<br />
JTTTT0645T383 <br />
<br />
The string ALWAYS begins w/ quotes and is ALWAYS delimited with quotes. I need the first value within the quotes returned.<br />
<br />
please give me some ideas, thanks
</div>
</div>


I'm trying to use the mid and instr functions to pull a substring from a string like this example:

"JTTTT0645T383"TUCKER, JAMmES"9999999999999999999999999""6/27/2037"""1/1/1900""

I would like to receive this value:
JTTTT0645T383 

The string ALWAYS begins w/ quotes and is ALWAYS delimited with quotes. I need the first value within the quotes returned.

please give me some ideas, thanks

need help with the mid and instr functions

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.