Windows 10: EXCEL sort sequence

Hi there

I'm trying to create a list of Movies in my DB in alphabetical order with folders A,B,C etc.

Is there a way to store for example "The Day the earth Stood Still - 1951" in D ignoring the word "THE" in the sort sequence if it's the first word of the film title. I also don't want to store the title as for example "Day the Earth stood still The"

Should be simple but I can't seem to construct a decent EXCEL formula that does this for me.

Cheers
jimbo

:)

 

People App Sorting Anomaly

I have found a strange anomaly in the way the People App sorts titles. If I put a Dr. title in front of the first name of a doctor, sometimes it is sorted into the D's and sometime it is sorted into first or last name sequence. I would actually like to
be able to reproduce the sequence where it is sorted by Ds so that all doctors are put into the same area. Anyone have any ideas or thoughts?

 

Explorer saved searches default to Content View/Descending Order in spite of being saved as Xtra Large Icon/Name (Ascending)

So, to summarise:

My problem is that Windows 10 search-ms files do not return the correct results, eg:

1) I define a search. The files originally appear in a default Layout/Sort-By sequence. Very quick, always correct.

2) I re-order the Sorting sequence to Name/Ascending and change the Layout to Xtra Large Icons. All seems fine.

3) I save the result to a search-ms file.

4) Opening that search-ms file in Notepad++ I see, for instance, the correct Sort-By instruction:

<sortList><sort viewField="System.ItemNameDisplay" direction="ascending"/></sortList>

5) I run the search but it still displays in the original/default Layout/Sort-By sequence - not the one I gave it.

To compound my confusion:

Sometimes the search-ms file starts to work properly if I Save it a second or third time - with no apparent change to the search-ms file itself (ie a simple Copy/Paste into Excel of the text of the search-ms file when it displays incorrectly and a second
Copy/Paste of the file when it is working shows exactly the same len())

This suggests that Windows maintains some other list of Layout/Sort-By definitions for search-ms "folders".

I know Windows maintains a list of Folder-related Views for ordinary Folders - and users often have problems with the fact that the list is too short. But I thought that as search-ms "files' (which seem to be treated as a special type of folder) contains
their own Layout/Sort-by in their actual definition they were not treated like that.

Hope that helps narrow down the problem...

 

Hi Jimbo,

this custom sort is possible....ofcourse! *Smile Let me explain two easy ways to do this.

1) Create an extra column and insert a formula like "IF(LEFT(xx;3)="The";MID(xx;4;LEN(xx));xx)
Now simply sort the database on this column.
It is nice to hide this column and write a litte bit VBA code to do the sort *Smile

2) Do the entire thing from VBA. The fastest way is to load the entire database into a collection and then do the sort in the memory and print the results.
However...if you are not used to working with collections this is very difficult. So another option is to loop through the database using the bubble algorithme (check internet for the code) and ofcourse don't forget to tell the code that, if the first word is "The", it sometime have to skip some letters.

Method 1 is the easiest. Method 2 is the most beautiful option.

Goodluck!

Greetz,

Rover

 

Hi there

thanks

that worked a treat (option 1).

Cheers
jimbo