strings and input files

  • Thread starter Thread starter Marco Trapanese
  • Start date Start date
M

Marco Trapanese

Hello,

I have to define a structure for a plain-text input file.
It should have some general text fields and a long table of values.
These values are grouped by rows and can be integers, floats, strings.

Here an example:

Title
Description
Others...

val11, val12, val13
val21, val22, val23

Where valxy could be:

10
45.2
Hello! This is a string, indeed.
-56.1234

Well, I have a couple of questions:

1) should I use an xml file?

Something like this:

<header>
Title
Description
Others...
</header>

<data>
val11, val12, val13
val21, val22, val23
</data>


2) how can I manage strings? Strings might contain ',' that is the
separator character. If I use double quotes ( "mystring" ) does VB
understand it's a string?

Thanks
Marco / iw2nzm
 
Marco said:
I have to define a structure for a plain-text input file.
Click to expand...
1) should I use an xml file?
Click to expand...

Yes!
Bear in mind that Xml is good for holding things and retrieving them,
but not so good at extracting values and then breaking them up (you have
to code for that) so break your data down as far as you (sensibly) can,
then you can read and reassemble items later.

Something like this would do:

<file>
<header
title="W"
description="X"
other_1="Y"
other_2="Z"
/>
<data>
<row number="1">
<col number="1" >10</col>
<col number="2" >45.2</col>
<col number="3" >Hello! This is a string, indeed.</col>
</row>
<row number="2">
<col number="1" >-56.1234</col>
<col number="2" >Gilligan&apos;s Island</col>
<col number="3" >42</col>
</row>
</data>
2) how can I manage strings? Strings might contain ',' that is the
separator character.
Click to expand...

Single quotes have to be escaped/encoded as &apos but, if you use any of
the Xml classes to manipulate your data (System.Xml Namespace), this
will all be taken care of for you.

HTH,
Phill W.
 
Phill said:
Yes!
Bear in mind that Xml is good for holding things and retrieving them,
but not so good at extracting values and then breaking them up (you have
to code for that) so break your data down as far as you (sensibly) can,
then you can read and reassemble items later.

Something like this would do:

<file>
<header
title="W"
description="X"
other_1="Y"
other_2="Z"
/>
<data>
<row number="1">
<col number="1" >10</col>
<col number="2" >45.2</col>
<col number="3" >Hello! This is a string, indeed.</col>
</row>
<row number="2">
<col number="1" >-56.1234</col>
<col number="2" >Gilligan&apos;s Island</col>
<col number="3" >42</col>
</row>
</data>
</file>
Click to expand...


[cut]

Thank you for your answer,
I will try this way!

Marco / iw2nzm
 
Back
Top