String.Format

[Jaroslav Jakes]

Hi,

crazy, can't find a simple way.

Have a table with columns: ElementValue, ElementFormat (both string-format)

Would like to format ElementValue according to ElementFormat
e.g.
ElementValue: 0000545
ElementFormat: #####.##

Result: 5.45

Do you have an idea?

Thanks and regards

Jari

[Morten Wennevik]

Hi Jari,

The problem is you don't have a decimal separator in your number, and to
my knowledge no formatting methods available will insert one based on a
format string.

You will have to create your own conversion code.
You don't say in what ways the elementvalue or elementformat may change,
but this is a general code that will transform the value to 5.45 based on
the format.

//format is elementformat, value is elementvalue
string result = "";
for(int i = 0, j = 0; i < format.Length; i++)
{
if(format[i] == '#')
{
result += value[j];
j++;
}
else
result += format[i];
}
result = result.TrimStart('0');

If you need it to be a number you can just parse the result instead of
using TrimStart.

--
Happy Coding!
Morten Wennevik [C# MVP]

[Jaroslav Jakes]

Hi Morten,

thanks for your feedback. As it seems, there is really no way without an
"format-engin".

Regards - Jari
"Morten Wennevik" <Mo************@hotmail.com> schrieb im Newsbeitrag
news:opsh95qmuuklbvpo@pbn_computer...

Hi Jari,

The problem is you don't have a decimal separator in your number, and to
my knowledge no formatting methods available will insert one based on a
format string.

You will have to create your own conversion code.
You don't say in what ways the elementvalue or elementformat may change,
but this is a general code that will transform the value to 5.45 based on
the format.

//format is elementformat, value is elementvalue
string result = "";
for(int i = 0, j = 0; i < format.Length; i++)
{
if(format[i] == '#')
{
result += value[j];
j++;
}
else
result += format[i];
}
result = result.TrimStart('0');

If you need it to be a number you can just parse the result instead of
using TrimStart.

--
Happy Coding!
Morten Wennevik [C# MVP]

[Nick Malik]

Jari,

Don't be silly:

if your format does not have a decimal, but you know the precision, just
insert the decimal:

int myInt = 54332;
float myFloat = myInt/100.0;
Console.Writeline("{0}",myFloat);

This used to be really common in Cobol days, when a byte of storage was
really expensive.

--- Nick

"Jaroslav Jakes" <jj****@eh-services.ch> wrote in message
news:eC**************@TK2MSFTNGP11.phx.gbl...

Hi Morten,

thanks for your feedback. As it seems, there is really no way without an
"format-engin".

Regards - Jari
"Morten Wennevik" <Mo************@hotmail.com> schrieb im Newsbeitrag
news:opsh95qmuuklbvpo@pbn_computer...

Hi Jari,

The problem is you don't have a decimal separator in your number, and to
my knowledge no formatting methods available will insert one based on a
format string.

You will have to create your own conversion code.
You don't say in what ways the elementvalue or elementformat may change,
but this is a general code that will transform the value to 5.45 based on the format.

//format is elementformat, value is elementvalue
string result = "";
for(int i = 0, j = 0; i < format.Length; i++)
{
if(format[i] == '#')
{
result += value[j];
j++;
}
else
result += format[i];
}
result = result.TrimStart('0');

If you need it to be a number you can just parse the result instead of
using TrimStart.

--
Happy Coding!
Morten Wennevik [C# MVP]

[Jaroslav Jakes]

Hi Nick,

at runtime, I just have informatin about value and format. So value's
datatype is 'unknown'...

I was too lazy to store information about datatype, because I thought, that
formating would be the easiest part of all.

Thank's - Jari
"Nick Malik" <ni*******@hotmail.nospam.com> schrieb im Newsbeitrag
news:yu0rd.170718$HA.160394@attbi_s01...

Jari,

Don't be silly:

if your format does not have a decimal, but you know the precision, just
insert the decimal:

int myInt = 54332;
float myFloat = myInt/100.0;
Console.Writeline("{0}",myFloat);

This used to be really common in Cobol days, when a byte of storage was
really expensive.

--- Nick

"Jaroslav Jakes" <jj****@eh-services.ch> wrote in message
news:eC**************@TK2MSFTNGP11.phx.gbl...

Hi Morten,

thanks for your feedback. As it seems, there is really no way without an
"format-engin".

Regards - Jari
"Morten Wennevik" <Mo************@hotmail.com> schrieb im Newsbeitrag
news:opsh95qmuuklbvpo@pbn_computer...

Hi Jari,

The problem is you don't have a decimal separator in your number, and to my knowledge no formatting methods available will insert one based on a format string.

You will have to create your own conversion code.
You don't say in what ways the elementvalue or elementformat may change, but this is a general code that will transform the value to 5.45 based on the format.

//format is elementformat, value is elementvalue
string result = "";
for(int i = 0, j = 0; i < format.Length; i++)
{
if(format[i] == '#')
{
result += value[j];
j++;
}
else
result += format[i];
}
result = result.TrimStart('0');

If you need it to be a number you can just parse the result instead of
using TrimStart.

--
Happy Coding!
Morten Wennevik [C# MVP]