<div>
It would depend on what's in the rest of the content of any field. If each is composed of simple ASCII characters in the range 0 to 0x7F, then you can search for 0x09, 0x0A or 0x0D and OR that character with 0x80 to set the high bit. Then when you read them back in, AND with 0x7F to mask out the high bits.<br />
<br />
If your fields can contain anything in the range 0 - 0xFF, then a different strategy will be required.<br />
<br />
Jim<br />

</div>


It would depend on what's in the rest of the content of any field. If each is composed of simple ASCII characters in the range 0 to 0x7F, then you can search for 0x09, 0x0A or 0x0D and OR that character with 0x80 to set the high bit. Then when you read them back in, AND with 0x7F to mask out the high bits.

If your fields can contain anything in the range 0 - 0xFF, then a different strategy will be required.

Jim


<div>
Hi Jim,<br />
<br />
I do have accents on certain characters as well... &nbsp;Like èéêèà &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ç<br />
<br />
I'm starting to think I should allow multiple lines and have markers for begin and end of each record. &nbsp;Just one character to delimit records, namely the | (bitwise or) character. &nbsp;So for each field, I escape all backslashes by doubling them all and then I replace any instances of | with a \|<br />
<br />
Do you think this is complete?<br />
<br />
Mike
</div>


Hi Jim,

I do have accents on certain characters as well...  Like èéêèà      ç

I'm starting to think I should allow multiple lines and have markers for begin and end of each record.  Just one character to delimit records, namely the | (bitwise or) character.  So for each field, I escape all backslashes by doubling them all and then I replace any instances of | with a \|

Do you think this is complete?

Mike

<div>
Oh - what do I use as begin and end record markers?
</div>


Oh - what do I use as begin and end record markers?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I am writing out a tab delimited file of records (1 record per line). &nbsp;My data sometimes contains tabs and CRLF pairs. &nbsp;How do I escape these items correctly and how do I unescape them?<br />
<br />
Thanks for your help!<br />
Mike
</div>
</div>


Hi Experts,
I am writing out a tab delimited file of records (1 record per line).  My data sometimes contains tabs and CRLF pairs.  How do I escape these items correctly and how do I unescape them?

Thanks for your help!
Mike

escaping values in import/export setting

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

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.

System Programming

An algorithm is a self-contained step-by-step set of operations to be performed. Algorithms exist that perform calculation, data processing, and automated reasoning. Starting from an initial state and initial input (perhaps empty), the instructions describe a computation that, when executed, proceeds through a finite number of well-defined successive states, eventually producing "output" and terminating at a final ending state. The transition from one state to the next is not necessarily deterministic; some algorithms, known as randomized algorithms, incorporate random input.