Using .NET string formatting, how do I format a string to display blank (empty string) for zero (0)?

Question

I am using a DataBinder.Eval expression in an ASP.NET Datagrid, but I think this question applies to String formatting in .NET in general. The customer has requested that if the value of a string is 0, it should not be displayed. I have the following hack to accomplish this:

<%# IIf(DataBinder.Eval(Container.DataItem, "MSDWhole").Trim = "0", "", 
    DataBinder.Eval(Container.DataItem, "MSDWhole", "{0:N0}"))  %>

I would like to change the {0:N0} formatting expression so that I can eliminate the IIf statement, but can't find anything that works.

Thanks for the formatting fix, Nick. I now see how to do that. — Randy Eppinger
– Randy Eppinger, Commented Feb 21, 2010 at 17:22

SLaks · Accepted Answer · 2010-02-17 17:02:10Z

10

You need to use the section separator, like this:

<%# DataBinder.Eval(Container.DataItem, "MSDWhole", "{0:N0;; }").Trim() %>

Note that only the negative section can be empty, so I need to put a space in the 0 section. (Read the documentation)

edited Feb 17, 2010 at 17:02

answered Feb 17, 2010 at 16:49

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

No Refunds No Returns Over a year ago

It's a good day. I learned something and it's not even 10 a.m. yet! I wish I could upvote twice.

to StackOverflow Over a year ago

Almost right, but N0 is a standard format and you need a custom format, e.g. "{0:#,##0;;}". You don't need to put a space in the third section.

Ruben Over a year ago

Caution, this won't work as you think it would: for MSDWhole != 0, you'd get "N<value>". N0 is not supported with group separators. Use "{0:#,0;; }"

Ruben Over a year ago

@Joe: you do need either a space or '' for the third group, as an empty group is ignored. {0:+A;-A;} returns +A for 0. With '' no Trim is needed.

to StackOverflow Over a year ago

@Ruben, you're right, it should be a hash digit placeholder, e.g. {0:#,##0;;#}

|

David · Accepted Answer · 2010-09-09 14:03:16Z

3

Given the accepted answer:

<%# DataBinder.Eval(Container.DataItem, "MSDWhole", "{0:N0;; }").Trim() %>

The a space is placed in the the 3rd position, however placing a # in the third position will eliminate the need to call Trim().

<%# DataBinder.Eval(Container.DataItem, "MSDWhole", "{0:N0;;#}") %>

answered Sep 9, 2010 at 14:03

David

19.8k13 gold badges68 silver badges88 bronze badges

1 Comment

Randy Eppinger Over a year ago

Dave, I tried this idea and it worked great! Dropping the trim is definitely an improvement. Thanks!

Samuel Neff · Accepted Answer · 2010-02-17 16:50:57Z

0

Use a custom method.

public static string MyFormat(double value) {       
    return value == 0 ? "" : value.ToString("0");
}

<%# MyFormat(Convert.ToDouble(Eval("MSDWhole"))) %>

answered Feb 17, 2010 at 16:50

Samuel Neff

75.3k18 gold badges144 silver badges186 bronze badges

Comments

Amgad Fahmi · Accepted Answer · 2010-02-17 16:52:59Z

0

Try to call a function while binding like this

<%# MyFunction( DataBinder.Eval(Container.DataItem, "MSDWhole") ) %>

and inside the function make the formatting you want

answered Feb 17, 2010 at 16:52

Amgad Fahmi

4,3493 gold badges22 silver badges18 bronze badges

Collectives™ on Stack Overflow

Using .NET string formatting, how do I format a string to display blank (empty string) for zero (0)?

4 Answers 4

7 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related