<div>
check this post also<br />
<br />
<a href="https://www.experts-exchange.com/questions/22606227/Escape-sequence-in-VB.html" rel="ugc">https://www.experts-exchange.com/questions/22606227/Escape-sequence-in-VB.html</a>
</div>


check this post also

https://www.experts-exchange.com/questions/22606227/Escape-sequence-in-VB.html [https://www.experts-exchange.com/questions/22606227/Escape-sequence-in-VB.html]

<div>
Thanks folks, for both these useful suggestions. &nbsp;I've assigned more or less equal points if that's ok with you. (one's for being easy, and the may be more accurate) Many thanks<br />
P
</div>


Thanks folks, for both these useful suggestions.  I've assigned more or less equal points if that's ok with you. (one's for being easy, and the may be more accurate) Many thanks
P

<div>
<div class="content wysiwyg-content">
Hi experts <br />
<br />
I have some data that's difficult to comma split because field 1 sometimes also contains a comma and sometimes not. I tried Split (LINEDATA, &quot;Chr(34),&quot; ) &nbsp;but it just delivers the whole line<br />
<br />
Is there a recognised vb6 split statement for data in this format? (below)<br />
<br />
&quot;21/07/2006&quot;,&quot;Bigg, Anne&quot;,&quot;1162&quot;,&quot;Private&quot;,&quot;18<wbr />/06/1949&quot;,<wbr />&quot;F&quot;,&quot;37799<wbr />8&quot;,&quot;GK&quot;,&quot;M<wbr />I50&quot;,<br />
&quot;22/07/2006&quot;,&quot;Script Fee&quot;,&quot;23965&quot;,&quot;Private&quot;,&quot;11<wbr />/01/1911&quot;,<wbr />&quot;&quot;,&quot;377382<wbr />&quot;,&quot;JC&quot;,&quot;MI<wbr />42&quot;,&quot;5.45&quot;<wbr />,<br />
<br />
Thanks 
</div>
</div>


Hi experts 

I have some data that's difficult to comma split because field 1 sometimes also contains a comma and sometimes not. I tried Split (LINEDATA, "Chr(34)," )  but it just delivers the whole line

Is there a recognised vb6 split statement for data in this format? (below)

"21/07/2006","Bigg, Anne","1162","Private","18/06/1949","F","377998","GK","MI50",
"22/07/2006","Script Fee","23965","Private","11/01/1911","","377382","JC","MI42","5.45",

Thanks 

split - on &quot;text&quot;,&quot;text,text&quot;,&quot;numeric&quot;

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.

split - on &quot;text&quot;,&quot;text,text&quot;,&quot;numeric&quot;

split - on "text","text,text","numeric"