locked
Custom sort / view of a document library RRS feed

  • Question

  • I have a document library that includes files that all have a numeric value at the end of the file name

    The files all start xxbud then a space then another five digits then a dash and a further 3 digits such as

    xxbud 11111-101    xxbud11500-111  xxbud 22220-222

    is there a way I can create a view so the files are sorted by the last 3 digits?

    I am using moss 2007

    Thanks

    Wednesday, August 29, 2012 9:01 AM

All replies

  • Hi,

      You can create custom view using sharepoint designer for reference:http://techtrainingnotes.blogspot.in/2008/11/sharepoint-group-by-on-more-than-2.html

    And  also  we can create web control for that view and we can use our own logic for shorting.

    Thanks,


    Selva.R


    • Edited by Selva R Wednesday, August 29, 2012 10:38 AM
    Wednesday, August 29, 2012 10:18 AM
  • You can also create new column of type (Calculated) and in the formula you can place something like:

    =RIGHT([Title],3)

    So the new field will hold the following values (the last three right digits) :

    101, 111, 222.

    then you can create a new view where you hide this Calculated field and using it.

    Wednesday, August 29, 2012 11:07 AM