Can I perform a substring operation on <%#Container.DataItem("Mileage")%>?

Can I perform a substring operation on <%#Container.DataItem("Mileage")%>? Similarly can I format a field as currency at display time <%#Container.DataItem("Price")%>.

I would like to truncate the last 3 positions of the mileage fielage and replace it with a "K". I would also like to format the price value as currency. Can I perform this operations at display time?

This is in the <ItemTemplate> section of a repeater:

    <tr class="summaryDetailRow">
    <td class="summaryItem1"><%#Container.DataItem("fldCameraPhoto")%></td>
    <td class="summaryItem2"><%#Container.DataItem("fldVehicleMakeLink")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Model")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Year")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Color")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Mileage")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Price")%></td>
    <td class="summaryItem2"><%#Container.DataItem("Stock Number")%></td>
    </tr>

Thank you!

Tim
bigmoxyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Bane83Connect With a Mentor Commented:
Try:

<%# DataBinder.Eval(Container.DataItem, "YourDataColumnName").ToString().Substring(x, y) %>

and:

<%# DataBinder.Eval(Container.DataItem, "Price", "{0:C2}") %>
0
 
bigmoxyAuthor Commented:
Perfect! Thank you!

Tim
0
All Courses

From novice to tech pro — start learning today.