XML String Problem

[MrPresident2k]

Hi,

I am reading a XML string from a database and writing into a file. The problem is I have some fraction values in the database. Iam using MSXML parser to read the XML string and write it. But it converts all the fraction to date and writes to the file.
For example if I have 5/8 in my XML string, it is written in file as 8-May.
I even tried CStr, but it didn't work. AmI doing something wrong?
I have given the code below.

strTempString = XMLDoc.childNodes(0).childNodes(j).childNodes(0).Text & "," & _
            strPriceKey & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(3).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(4).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(7).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(8).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(2).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(5).Text & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(6).Text & "," & _
            CStr(XMLDoc.childNodes(0).childNodes(j).childNodes(11).Text) & "," & _
            XMLDoc.childNodes(0).childNodes(j).childNodes(10).Text & "," & _
        XMLDoc.childNodes(0).childNodes(j).childNodes(9).Text
        strFileArray(j) = strTempString
        intFnum = FreeFile
        Open strFilename For Output Lock Write As #intFnum
        For i = 0 To UBound(strFileArray)
            Print #intFnum, strFileArray(i)
        Next i
        Erase strFileArray
        Close #intFnum

In the above code
CStr(XMLDoc.childNodes(0).childNodes(j).childNodes(11).Text)
is the fractional part.

Thanks,
Pres

[MartinLiss]

In the code where you read xml text, put a breakpoint on the line and see if the fraction is still there or if xml has already converted it to a date. If it is already converted and you can control how the xml is stored in the database, put CDATA tags around the data like below and see if that fixes the problem.

![CDATA[This is 5/8]]

[MrPresident2k]

Thanks for replying,

I tried that and while reading the XML, it was in fraction. The problem was with the Excel. When ever excel reads a fraction, it always taked it as a date. The solution I found out is that, on adding space before the fraction makes it read as a fraction and not as a date. Say instead of '5/8' Iam inserting ' 5/8' in the file.

Thanks,
Pres.

[MartinLiss]

That will cause it to left-justify (with a space in front of it) in the cell. Try inserting a 0 in front. In other words 0-space-5/8. That's the normal way.