Dataview table group by substring() shows the substring() and file.name as -

[S1000RR]

Perfect