<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a database with a few fields and I converted the information of the database to a text file, &nbsp;now I want to read the information from the text file, the thing I would like some help on is on how to copy a piece from the string from a certain char(&amp;) until the next char(&amp;) and then delete the first piece and then copy the next piece again... Can any Expert please help me with this..<br />
<br />
Thanx in advance<br />
<br />
Here is an example of the record in text format:<br />
<br />
OAK&amp;12299&amp;OAK12299&amp;783&amp;1&amp;6<wbr />221&amp;112&amp;81<wbr />256&amp;13/02/<wbr />2009&amp;43&amp;&amp;&amp;<wbr />&amp;2&amp;79016&amp;P<wbr />HILANI &nbsp;NJOBE&amp;727.875&amp;3276&amp;0&amp;Liter<wbr />s entered by pieter<br />

<pre><code class="code-1 nolinks" id="code-260882"><span>OAK&amp;12299&amp;OAK12299&amp;783&amp;1&amp;6221&amp;112&amp;81256&amp;13/02/2009&amp;43&amp;&amp;&amp;&amp;2&amp;79016&amp;PHILANI  NJOBE&amp;727.875&amp;3276&amp;0&amp;Liters entered by pieter</span>
</code></pre>
</div>
</div>


Hi Experts,

I have a database with a few fields and I converted the information of the database to a text file,  now I want to read the information from the text file, the thing I would like some help on is on how to copy a piece from the string from a certain char(&) until the next char(&) and then delete the first piece and then copy the next piece again... Can any Expert please help me with this..

Thanx in advance

Here is an example of the record in text format:

OAK&12299&OAK12299&783&1&6221&112&81256&13/02/2009&43&&&&2&79016&PHILANI  NJOBE&727.875&3276&0&Liters entered by pieter

Copy string from char to next char

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).