> Is there a function I can call to first convert the slashes to one
> unified format before applying the substring?

translate(.,'\','/')