<div>
Is it a hard space?<br />
<br />
Portfolio = Split(replace(varArray3(m)<wbr />, chr(160), &quot;&nbsp;&quot;), &quot;&nbsp;&quot;)(0)<br />
<br />
Chris
</div>


<div>
Is this VB.NET or VBScript?
</div>


<div>
I get subscript out of range error. The space just spearates 2 words. There is no limit to the length of a word.<br />
Thanks
</div>


<div>
If it isn't a hard space then what is it ...<br />
<br />
when it 'breaks on the error, type the string into the immediate window ... ctrl + G to display it<br />
<br />
Now find where you think the space is in the word and type into the immediate window:<br />
<br />
<br />
?asc(mid(varArray3(m), 5))<br />
<br />
replace 5 with the character position of the space ... what do you get?<br />
<br />
<br />
Chris
</div>


<div>
?varArray3(m)<br />
<br />
will display the actual string<br />
<br />
Chris
</div>


<div>
&gt; <i>I get subscript out of range error.</i><br />
<br />
That can happen because varArray3(0) is out of range (or the array isn't dimensioned), or because varArray3(m) is an empty string. Split(&quot;&quot;) returns an array with -1 as upper bound.<br />
<br />
(°v°)
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have an array and I am looping the array. Each row of the array will have an entry like A B .I want to split the record when I come across the first space and store it in another variable. How do I achieve it. I am unable to do this with split function.<br />
<br />
Thanks<br />
<br />
Shilpi 
<pre><code id="code-8191927">Dim m As Long
    m = 0
    Do Until IsEmpty(varArray3)
    Dim Portfolio As String
    Portfolio = Split(varArray3(m), &quot; &quot;)(0)
    Loop</code></pre>
</div>
</div>


Hi Experts,

I have an array and I am looping the array. Each row of the array will have an entry like A B .I want to split the record when I come across the first space and store it in another variable. How do I achieve it. I am unable to do this with split function.

Thanks

Shilpi 

Is it a hard space?

Portfolio = Split(replace(varArray3(m), chr(160), &quot; &quot;), &quot; &quot;)(0)

Chris

I get subscript out of range error. The space just spearates 2 words. There is no limit to the length of a word.
Thanks

If it isn&#39;t a hard space then what is it ...

when it &#39;breaks on the error, type the string into the immediate window ... ctrl + G to display it

Now find where you think the space is in the word and type into the immediate window:


?asc(mid(varArray3(m), 5))

replace 5 with the character position of the space ... what do you get?


Chris

?varArray3(m)

will display the actual string

Chris

&gt; I get subscript out of range error.

That can happen because varArray3(0) is out of range (or the array isn&#39;t dimensioned), or because varArray3(m) is an empty string. Split(&quot;&quot;) returns an array with -1 as upper bound.

(°v°)

Splitting when space

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Visual C++ (often abbreviated as MSVC or VC++) is an integrated development environment (IDE) product from Microsoft for the C, C++, and C++/CLI programming languages. It features tools for developing and debugging C++ code, especially code written for the Microsoft Windows API, the DirectX API, and the Microsoft .NET Framework. Many applications require redistributable Visual C++ packages to function correctly and are often installed independently of applications, allowing multiple applications to make use of the package while only having to install it once

Visual C++.NET

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.