473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

xml file format

Hi, All,

I create xml file, when open in notepad (or any text editor), the file
looks like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340 </Data3>
<Table1</Root>

That means it doesn't show each open and close tag one line. I want the file
look like below

<Root>
<Table1>
<Data110 </Data1>
<Data220 </Data2>
<Data340 </Data3>
<Table1>
</Root>

Can anyone help this out?

Thank you for your time
Martin

Nov 16 '06 #1
4 848
Was that a typo in the closing <Table1tag? You forgot the "/" character.
Also, you need to add in the xml header as the first line.

<?xml version="1.0"?>

-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
Hi, All,

I create xml file, when open in notepad (or any text editor), the
file looks like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340
</Data3<Table1</Root>

That means it doesn't show each open and close tag one line. I want
the file look like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340
</Data3<Table1</Root>

Can anyone help this out?

Thank you for your time
Martin

Nov 16 '06 #2
martin1 wrote:
I create xml file ... the file looks like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340 </Data3>
<Table1</Root>

I want the file look like below

<Root>
<Table1>
<Data110 </Data1>
<Data220 </Data2>
<Data340 </Data3>
<Table1>
</Root>
Why?

The former is (syntactic errors notwithstanding) perfectly good XML and
any XML reader will happily crunch its way through it.
The presence or absence of whitespace is irrelevant.

There /may/ be some sort of "whitespace" property on the XML object that
will put the line-breaks in, but they /really/ don't matter.

Regards,
Phill W.
Nov 17 '06 #3
you are right, the close tag is </Table1>. But when add the header in he
first line, still no line-break, any more advice?

Thaks,
Martin

"Tim Patrick" wrote:
Was that a typo in the closing <Table1tag? You forgot the "/" character.
Also, you need to add in the xml header as the first line.

<?xml version="1.0"?>

-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
Hi, All,

I create xml file, when open in notepad (or any text editor), the
file looks like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340
</Data3<Table1</Root>

That means it doesn't show each open and close tag one line. I want
the file look like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340
</Data3<Table1</Root>

Can anyone help this out?

Thank you for your time
Martin


Nov 17 '06 #4
Hello Martin,
I create xml file, when open in notepad (or any text editor), the file
looks like below

<Root<Table1<Data110 </Data1<Data220 </Data2<Data340
</Data3>
<Table1</Root>

That means it doesn't show each open and close tag one line. I want the
file
look like below

<Root>
<Table1>
<Data110 </Data1>
<Data220 </Data2>
<Data340 </Data3>
<Table1>
</Root>

Can anyone help this out?
I don't know why you want separate line, but this job could do a simple
replace
if you have a fixed structure, in the sample above you could do this steps :

a) Replace "<Table" with "{CrLf}<Table"
b) Replace "<Data" with "{CrLf}<Data"
c) Replace "</Table" with "{CrLf}</Table"
d) Replace "</Root" with "{CrLf}</Root"
Regards

Holger
Nov 19 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Query Builder | last post by:
I am new to BCP. Can anyone help me understand this? I tried searching the BOL but it doesnt show much help on syntex. Lets say I have a simple table and want to out put the records into a file....
0
by: Lokkju | last post by:
I am pretty much lost here - I am trying to create a managed c++ wrapper for this dll, so that I can use it from c#/vb.net, however, it does not conform to any standard style of coding I have seen....
1
by: Namratha Shah \(Nasha\) | last post by:
Hi All, This is a resource file generation tool which converts an xml based resource formats to .net resource file i.e. (.resources) and vice-versa. Today we will see how we will generate ...
8
by: suresh_C# | last post by:
Dear All, What is difference between Portable Executable (PE) file and a Assembly? Thanks, Mahesh
2
by: KR | last post by:
I am trying to copy the data in excel file into a table using the bcp and this is the code that I have. However the bcp utility does not seem to create a format file, which I thought it should...
1
by: steve | last post by:
Hi all, Here's some work in progress that should allow you to run a batch file as a custom action in a VS deployment project. Yup I know you can use js or wsh, but the target may not have...
9
by: JimmyKoolPantz | last post by:
IDE: Visual Studio 2005 Language: VB.NET Fox Pro Driver Version: 9.0.0.3504 Problem: I currently have a problem altering a DBF file. I do not get any syntax errors when running the program. ...
3
by: forest demon | last post by:
for example, let's say I do something like, System.Diagnostics.Process.Start("notepad.exe","sample.txt"); if the user does a SaveAs (in notepad), how can i capture the path that the user...
3
by: karthikla | last post by:
Hi Experts, Could you please help me on how to get access 2002 file format exactly while doing conversion from Access 97 file format by DBEngine.CompactDatabase() function? Code: Private...
5
by: sonu | last post by:
hey good morning ...... how to convert a video file in .flv format in php for linux hosting......is there any package whis provide this facility . Can i use ffmpeg for linux hosting...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.