Need help removing ";" separator from items within an array, VBscript

Question

My code is pulling from a data cells that lists multiple file paths and use semicolons " ; " as the separator. After spliting the data and placing it into an array, I need to remove the semicolons. otherwise my file paths are invalid when they enter the loop.

To clarify: My code works when there is only one file path in the data cell and dies once it hits a cell with multiple paths because of the ";"

ANY HELP would be much appreciated.

My code is the following:

<%
strValue = RS("ATTACHMENTS")
strAryWords = Split(strValue, ";")

' - strAryWords is now an array
For i = 0 to Ubound(strAryWords)
    Set fso = Server.CreateObject("Scripting.FileSystemObject")
    Set fileObject = fso.getFile(strAryWords(i))

    Response.Write "<TH><TR align=left><TD>" & strAryWords(i) &"  "& fileObject.Size &"  "&"<img src=images/up.gif><BR></TD></TR>"

    Set fileObject = Nothing
    Set fso = Nothing  
Next
%>

Please state which language you are using (visual basic?), and tag the question accordingly. — Jason S
– Jason S, Commented Jan 17, 2009 at 15:32
Sebastian why did you retag VB.NET when the person that asked the question retaged VBScript? — cgreeno
– cgreeno, Commented Jan 17, 2009 at 15:38

Patrick Cuff · Accepted Answer · 2009-01-17 21:52:21Z

1

If the problem is strValue has a trailing ';', change your code to this:

strValue = RS("ATTACHMENTS")
strAryWords = Split(strValue, ";")


' - strAryWords is now an array
For i = 0 to Ubound(strAryWords)
    If strAryWords(i) <> "" Then
        Set fso = Server.CreateObject("Scripting.FileSystemObject")
        Set fileObject = fso.getFile(strAryWords(i))

        Response.Write "<TH><TR align=left><TD>" & strAryWords(i) &"  "& fileObject.Size &"  "&"<img src=images/up.gif><BR></TD></TR>"

        Set fileObject = Nothing
        Set fso = Nothing
    End If
NEXT

answered Jan 17, 2009 at 21:52

Patrick Cuff

30.1k12 gold badges70 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need help removing ";" separator from items within an array, VBscript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related