Subject:Text 2 XML Author:p s Date:12 May 2005 12:13 PM
Hi I am attaching Text file which I want to convert into XML format. I had tried to convert as per yr demo but I could not get the correct result I think. So pls look at it n guuide me to do the correct way.
Subject:Text 2 XML Author:p s Date:12 May 2005 11:45 PM Originally Posted: 12 May 2005 11:41 PM
Hi Tony Thx for the reply. I am not able to make the changes as u want to do. Becoz I am exporting Database file in to Text format by using FileMaker software. I had also attached my database file for yr reference.<br>
So Pls guide me the second alternative to get the right XML format from the given Text file.<br>
Subject:Text 2 XML Author:Tony Lavinio Date:16 May 2005 11:17 AM
Because FileMaker seems to emit those VT (0x0B) entries, we need a way
to make them NOT go to the output XML.
One course is to treat them as 'Component Separators'. To do that, set
the property of that name to VT. This however may cause some of the
fields that are delimited by double-quotes to end up containing those
quotes, so you'll have to select those fields and add a ,34 to the
characters to be trimmed - see the Left Padding and Right Padding
We've made a change here for our next patch release, due out at the end
of the month, which will eliminate the 0x0B entries from getting to the
output XML and causing this trouble, so if you can wait until then, the
problem will just go away for you.