パス.フルパス→ディレクトリ名（dirname）

Python

py

os.path.dirname(path)

Bash

bash

dirname $path
${path%/*}

Ruby

rb

File.dirname(path)

PowerShell

powershell

Split-Path -Leaf $fullpath

Excel

xlsx

=LEFT(A1,FIND(">",SUBSTITUTE(A1,"/",">",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))),1)-1)