Split filename inside For each file in a folder

[Rupesh_Parle]

Hi everyone,

I have a folder containing bunch of files with naming (Report_BuName.xlsx). I am looping through each file in a folder to preform some actions where I require the BuName of each file.

Thanks in advance!

[lrtetala (Lakshman Reddy)]

Hi @Rupesh_Parle

Try this

System.Text.RegularExpressions.Regex.Match(Input.ToString,"(?<=Report_)(\w+)").Value

Cheers!!

[lrtetala (Lakshman Reddy)]

@Rupesh_Parle

You’re using for each file in folder so take input as Currentfile.Name

Or

Directly you can give this
Currentfile.Name.Split(“_”)(1).Split(“.”)(0)

Input="Report_BuName.xlsx"
Input.Split("_")(1).Split(".")(0)

Hope this helps!!

[Yoichi]

Hi,

FYI, another approach:

 System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(CurrentFile.Name),"[^_]+$").Value

Regards,

[Anil_G (Anil Gorthi)]

@Rupesh_Parle

Inside the for each file in folder use the following

CurrentFile.Name.Split({"_","."},3,StringSplitOptions.None)(1)

Hope this helps

Cheers