<div>
That was perfect Fernando. I guess I need to review all the string methods. :)
</div>


That was perfect Fernando. I guess I need to review all the string methods. :)

<div>
<div class="content wysiwyg-content">
I'm testing a list of workstations that will be sent as comma delimited to a SQL 2005 SP whereby the @Workstation variable will receive this list.<br />
I went to copy and past some workstations from an Excel sheet and when I went to add this list to the Properties/Debug/Command line arguments box, and went to store them in an array,<br />
I noticed that the workstations in the arrary were being list like this:<br />
B001617259BA7,\r\nB001E371<wbr />E21B2,\r\n<wbr />B001422C95<wbr />811,\r\nB0<wbr />01C25100C3<wbr />1,\r\nB001<wbr />422D9BE9B,<wbr />\r\nB00217<wbr />091E3A0,et<wbr />c. What methods are there to remove the Newline \r\n Escape sequence characters before adding them into VS 2008 for Debug testing or when sent to the SP?<br />
Thanks for your help Experts,<br />
Wally<br />

<pre><code id="code-292436">[0] = &quot;B001617259BA7,\r\nB001E371E21B2,\r\nB001422C95811,\r\nB001C25100C31,\r\nB001422D9BE9B,\r\nB00217091E3A0,\r\nB0015605A5819,\r\nB00163666A181,\r\nB0021709A9EF8,\r\nB001C23525C6B,\r\nB00188BD375BF,\r\nB0016179FBF81,\r\nB001C25143F9D,\r\nB0014C2CA6C1F,\r\nB001...
</code></pre>
</div>
</div>


I'm testing a list of workstations that will be sent as comma delimited to a SQL 2005 SP whereby the @Workstation variable will receive this list.
I went to copy and past some workstations from an Excel sheet and when I went to add this list to the Properties/Debug/Command line arguments box, and went to store them in an array,
I noticed that the workstations in the arrary were being list like this:
B001617259BA7,\r\nB001E371E21B2,\r\nB001422C95811,\r\nB001C25100C31,\r\nB001422D9BE9B,\r\nB00217091E3A0,etc. What methods are there to remove the Newline \r\n Escape sequence characters before adding them into VS 2008 for Debug testing or when sent to the SP?
Thanks for your help Experts,
Wally

Need to send a list of workstations to a SQL SP / its variable, but need to remove /r/n

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.