Extract Name from Path

[Priya Bange]

Hi Experts,

I have multiple file paths that are based on the Server Name like below

ServerName = 'ZKHG-01-2019'

C:\Output\ZKHG-01-2019\Files\DBName

C:\Input\ZKHG-01-2019_1\Files\DBName

C:\Input\backup\processing\C:\Input\ZKHG-01-2019_02\

D:\Output\Requesting\ServerFiles\ZKHG-01-2019_03\




Could you please support with a method that helps me extract the Server Name or Server Name matching text. Output below

Output

ZKHG-01-2019
ZKHG-01-2019_1
ZKHG-01-2019_02
ZKHG-01-2019_03


Thanks

Priya

Continue reading...