Sort by name and order ignores underscore

[Millzey]

Would like to sort a big list of folders, some with no underscores and some with underscores. I would be super userful to ignore underscores (or any specified character such as "." or "-", but underscore is all I need) to give the following sort:

The Blue Folder
The_Blue_Folder2
The_Red_Folder
The Red Folder2

Instead of current sort:

The Blue Folder
The Red Folder
The_Blue_Folder2
The_Red_Folder2

I have references to folders/files containing underscores, so renaming/replacing underscores to spaces wouldnt work for me.

Any easy workaround or existing feature I might be missing? Thanks!

[highend]

Use a custom column that returns each folder name with "_|.|-" replaced with " "?

so renaming/replacing underscores to spaces wouldnt work for me.

That wouldn't matter, the column would only be used for sorting...

[Millzey]

Obvious thinking! thanks a bunch I'll try it