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.
tahnks
Ps
Subject:Text 2 XML Author:Tony Lavinio Date:12 May 2005 01:49 PM
The problem with that file is that it contains lots of VT (0x0B)
characters, and characters with a Unicode value of less than 0x20,
with the exception of white space, can't be rendered in XML.
First, is there any chance you can get an input file without those
characters? That would be simplest. Otherwise, we'll explore some
other options.
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>
thanks
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
properties.
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.
Subject:Text 2 XML Author:Tony Lavinio Date:17 May 2005 10:49 AM
When the patch is available, a small icon in the lower right
corner of your Stylus Studio window will start flashing. Clicking
on it will bring you to the update page.