Read file name some text?

Help Activities
, ,
1

How to read file name (only number yellow highlight)
I want number after text Charge_ and before _ as below.

image

I want output round 1 = 473 , round 2 = 594 , round 3 = 649

Please guide me about it.

2

Hi @fairymemay

Hope this helps:

image

Thanks

3

@vinithareddyk123 What activity for use in uipath?

4

Hi @fairymemay,

You can use a for loop to get the file name first
For File in Directory.GetFiles(YOURPath,“*.pdf”)

Use the File.ToString as input to Matches activity and use the regex expression to extract the number : Charge_(?P<ItemNumber>\d+)_

Your variables will then be accessible in

YourRegexOutMatches(0).Groups(1).ToString

5

Hi @fairymemay

You can write inside assign activity also.

Use for each to loop through the files in folder using Directory.getFiles(“YourFolderPath”,“*pdf”)
and later passed the item value to the regex expression as shown below.

image

Output:
image

6

Hi

Hope these steps would help you resolve this

—use a assign activity like this
Arr_filepath = Directory.GetFiles(“your folder path”,”*.pdf”)

Where arr_filepath is a array fo string variable

—now use a FOR EACH loop and pass the above variable as input and change the type argument as string

—inside the loop use a writeline activity like this

Split(Split(item,”“)(1).ToString,”“)(0).ToString

This will give the value you want in output panel

Here we are trying to split the text from first underscore and again splitting that with first underscore

First we will get this
473_069990
Next will get this
473

Both is done in a single expression

Cheers @fairymemay

1 Like
7

@fairymemay - please check this post…

Here instead of change it to (1) …

image
image947Ă—63 3.63 KB

StrArrayNum =  Directory.GetFiles("YourFolderName","*.pdf").select(Function(x) path.GetFileNameWithoutExtension(x).split("_"c)(1)).toarray

Here StrArrayNum is of variable type String Array

1 Like
8

Another option would be to Split on _ and get element 1.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.