IfEmpty error when empty

kyle shapiro asked on May 4, 2015 22:02

Hi everyone, I have the following line of code within one of my transformations:

<%# IfEmpty(Eval("OfficeFax"),"",(string.Format("{0:Fax: (###) ###-####}", Int64.Parse(Eval("OfficeFax").ToString())))) %>

here it is again expanded for easier reading:

<%#
    IfEmpty(
        Eval("OfficeFax"),
        "",
        (string.Format(
            "{0:Fax: (###) ###-####}",
            Int64.Parse(
                Eval("OfficeFax").ToString()
            )
        ))
    )
%>

Is there a mistake in my logic? This works great for formatting 10 digit fax or phone numbers, but when I leave the field empty, I get a databinding error.

[CMSAbstractTransformation.DataBind]: Input string was not in a correct format.

I think the IfEmpty method doesn't like all the stuff I'm throwing into it. Is there a better way of writing the same thing? The field is stored as text, not a number. Thanks.

ifempty

Correct Answer

Jim Spillane answered on May 5, 2015 17:17

That is strange. IfEmpty() should return the second parameter if the first is null.

Here is one without the IfEmpty()... <%# (Eval("OfficePhone") != null && Eval("OfficePhone").ToString().Length > 0) ? Convert.ToInt64(Eval("OfficePhone")).ToString("Fax: (###) ###-####") : "" %>

0 votesVote for this answer Unmark Correct answer