Simple Regex or VB Expression to split

Help Studio
1

I need to get the name from the File inside the Folder

Folder Path : “C:\RPA\Dev\Test\Buyer Files”
This Folder has some files

Raj Buyer.csv
Rahul Buyer.csv
Pooja Buyer.csv

I need the Names like:
Raj
Rahul
Pooja.

I use For Each and ‘FileName’ in Directory.GetFiles(MyFolder)
I used Assign
BuyerName = split(FileName, " "c).First

but getting only : C:\RPA\Dev

Thanks.

2

Hey!

Try this:

  1. Take one assign inside the for each pass the expression like this
FileName = Path.GetFileNameWithoutExtension(Item)

This will give you the full Name

Now you can use like this to get the first name

FirstName.Split(" "C)(0)

This will give you the first Name

Reference:

FirstName
FirstName1314×621 20 KB

Regards,
NaNi

3

Hi @Gagan_Chaudhari

You can try this approach

image
image881×571 21.5 KB

xaml for reference

GetBuyerName.xaml (6.3 KB)

4

Hi,

Another solution:

If there is possibility filename doesn’t contain whitespace, the following might be better. (This expression doesn’t throw exception even if there is no whitespace. It returns whole filename without extension)

System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(filename),"^\S+").Value

Regards,

5

filepath.replace(folderpath+“",”")

try this it will give you filename