<div>
I changed it to this.. but now it looks like it works fine for me.<br />

<pre><code id="code-8148875">outputfile.WriteLine strcomputer &amp; &quot;,&quot; &amp; folder &amp; &quot;,&quot; &amp;  Replace(fsize, &quot;,&quot;, &quot;&quot;)  '</code></pre>
</div>


I changed it to this.. but now it looks like it works fine for me.


outputfile.WriteLine strcomputer & "," & folder & "," &  Replace(fsize, ",", "")  '

<div>
:-) Sorry, I've thought that comma is decimal separator. In my place (Ukraine) decimal separator is usually comma, but some software uses a dot instead. But if you have commas as thousands separator, then there is really no need to replace them with dots.
</div>


:-) Sorry, I've thought that comma is decimal separator. In my place (Ukraine) decimal separator is usually comma, but some software uses a dot instead. But if you have commas as thousands separator, then there is really no need to replace them with dots.

<div>
<div class="content wysiwyg-content">
I am running a vb script that saves to a csv file. I have a number that is coming over with comas included so it is causing problems when I open it &nbsp;up in excel. Can anyone tell me how to format this so that it still works the same but the output of fsize does not have any commas?<br />
<br />
thanks for your help!<br />
<br />
<br />

<pre><code id="code-8148856">If InStr(strText,&quot;Size:         &quot;)&gt;0 Then
            fsize=Replace(strText,&quot;Size:         &quot;,&quot;&quot;)
            fsize=Replace(fsize,&quot; bytes&quot;,&quot;&quot;)
            fsizedbl=CDbl(fsize)
           ' WScript.Echo &quot;File size &quot; &amp; fsizedbl
            outputfile.WriteLine strcomputer &amp; &quot;,&quot; &amp; folder &amp; &quot;,&quot; &amp;  fsize
            Exit Do
        End If</code></pre>
</div>
</div>


I am running a vb script that saves to a csv file. I have a number that is coming over with comas included so it is causing problems when I open it  up in excel. Can anyone tell me how to format this so that it still works the same but the output of fsize does not have any commas?

thanks for your help!



Change number format

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.