String Alignment Problem

[Rahul]

Friends,

My Problem is related to writing a text file from a database
using .Net. in a particular string format.
I have a dataset with a table, let suppose in this table there are
three fields.
- Code
- Description
- Amount

At the time of writing a text file I use in a for loop -

String.Format("{0,10}{1, 40} {2,-10}", DS.Table(0).Row(i)
("Code").ToString(), DS.Table(0).Row(i)("Description").ToString(),
DS.Table(0).Row(i)("Amount").ToString())
But the problem is related to the alignment. Data comes like in
following format:

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
I want Data comes in following proper alignment format.

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
So anybody knows the solutions of this problem, please and please
reply imediately, its urgent.

Rahul

[Matthias Tacke]

Rahul wrote:

Friends,

My Problem is related to writing a text file from a database
using .Net. in a particular string format.
I have a dataset with a table, let suppose in this table there are
three fields.
- Code
- Description
- Amount

At the time of writing a text file I use in a for loop -

String.Format("{0,10}{1, 40} {2,-10}", DS.Table(0).Row(i)
("Code").ToString(), DS.Table(0).Row(i)("Description").ToString(),
DS.Table(0).Row(i)("Amount").ToString())

String.Format("{0,10}{1, 40} {2,-10}",
does not cut to 10,40 and 10 places - if the content is longer it will
puzzle your output.

For testing I would insert a delimiter:
String.Format("{0,10}|{1, 40}|{2,-10}",

But the problem is related to the alignment. Data comes like in
following format:

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
I want Data comes in following proper alignment format.

01Code 01Desc 2000

12345678901234567
Strange, why do you use {0,10} if it should be {0,17} ?

02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
So anybody knows the solutions of this problem, please and please
reply imediately, its urgent.

Use the format with proper number of places or use

String.Format("{0,10}{1, 40} {2,-10}", _
Strings.Left(DS.Table(0).Row(i)("Code").ToString() ,10), _
Strings.Left(DS.Table(0).Row(i)("Description").ToS tring(),40), _
DS.Table(0).Row(i)("Amount").ToString())

requires Imports Microsoft.VisualBasic

--
Greetings
Matthias

[Hal Rosser]

"Rahul" <ve**********@gmail.comwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...

Friends,

My Problem is related to writing a text file from a database
using .Net. in a particular string format.
I have a dataset with a table, let suppose in this table there are
three fields.
- Code
- Description
- Amount

At the time of writing a text file I use in a for loop -

String.Format("{0,10}{1, 40} {2,-10}", DS.Table(0).Row(i)
("Code").ToString(), DS.Table(0).Row(i)("Description").ToString(),
DS.Table(0).Row(i)("Amount").ToString())
But the problem is related to the alignment. Data comes like in
following format:

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
I want Data comes in following proper alignment format.

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
So anybody knows the solutions of this problem, please and please
reply imediately, its urgent.

out of the many ways to do this, you may want to look at the padLeft and
padRight methods of the String object.
These methods can be used to left-align within a column - or right-align in
a column. It adds (pads) spaces to the left or to the right of the content -
you decide how many.
I think these methods were made for programmers to generate reports.

[PlatinumBay]

Rahul,

One thing you could try is to pad each field using the String object's
PadLeft and PadRight methods, such as:

String.Format("{0,10}{1, 40} {2,-10}",
DS.Table(0).Row(i)("Code").ToString().PadRight(15, " "c),
DS.Table(0).Row(i)("Description").ToString().PadRi ght(15, " "c),
DS.Table(0).Row(i)("Amount").ToString().PadRight(1 5, " "c))

The downside to this is that you have to know ahead of time what the maximum
length is for each field.
Hope this helps,

Steve
"Rahul" <ve**********@gmail.comwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...

Friends,

My Problem is related to writing a text file from a database
using .Net. in a particular string format.
I have a dataset with a table, let suppose in this table there are
three fields.
- Code
- Description
- Amount

At the time of writing a text file I use in a for loop -

String.Format("{0,10}{1, 40} {2,-10}", DS.Table(0).Row(i)
("Code").ToString(), DS.Table(0).Row(i)("Description").ToString(),
DS.Table(0).Row(i)("Amount").ToString())
But the problem is related to the alignment. Data comes like in
following format:

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
I want Data comes in following proper alignment format.

01Code 01Desc 2000
02Code 02Desc 3000
03CodeABC 03Desc 4000
04xyz 04Desc 5000
So anybody knows the solutions of this problem, please and please
reply imediately, its urgent.

Rahul

[Matthias Tacke]

PlatinumBay wrote:
....

String.Format("{0,10}{1, 40} {2,-10}",
DS.Table(0).Row(i)("Code").ToString().PadRight(15, " "c),
DS.Table(0).Row(i)("Description").ToString().PadRi ght(15, " "c),
DS.Table(0).Row(i)("Amount").ToString().PadRight(1 5, " "c))

The downside to this is that you have to know ahead of time what the maximum
length is for each field.

Hi Steve,
Public Function PadRight(ByVal totalWidth As Integer) As String
Member of System.String

uses the spcae by default.

The c in _" "c")_ in your above code seems to be a typo?
--
Greetings
Matthias

[Andrew Morton]

Matthias Tacke wrote:

PlatinumBay wrote:
...

>DS.Table(0).Row(i)("Code").ToString().PadRight(15 , " "c),

The c in _" "c")_ in your above code seems to be a typo?

It tells the computer that it's a single character rather than a string of
one character.

Andrew