String manipulation problem

[BigM]

Hi,

I have a text file in which fields are delimited by #~

I am wanting a method stripping the field values into variables for processing.

Any Ideas?

Thanks [sig][/sig]

 

[RobSchultz]

I assume you are already using the FileSystemObject to get each line of text. We'll start from there...

<%
' strTextLine would be you FSO line
strTextLine = &quot;This is a test.#~This is also a test.#~This, as well, is a test.#~A test, is this.&quot;

Dim arrTemp
Dim maxCount
Dim i

arrTemp = Split(strTextLine,&quot;#~&quot;)

maxCount = UBound(arrTemp)

For i = 0 to maxCount
 Response.Write &quot;Index &quot; & i & &quot;: &quot; & arrTemp(i) & &quot;<br>&quot;
 ' here instead you could pass each individual array value into the proper variable
Next
%>

Hope it helps, [sig]<p>Rob<br><a href=mailto:robschultz@yahoo.com>robschultz@yahoo.com</a><br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
"Focus on the solution to the problem,<br>
not the obstacles in the way."<br>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[/sig]