How to extract only a part of the text and save it in a variable

Help Robot
,
1

Hi Guys!

I have the below filename :
D:\Users\u326509\Documents\UiPath\CSOD_OfferLetter_RE_3\InputFiles\Vigneron Christophe_req5658.xlsm

I need to extract the number 5658 from the filename and use it in the URL below :
https://Bpost-pilot-csod.com/driver.aspx?routename=ATS/RecruitingManagement/ManageApplicants&id=5658&k=1

Please let me know how to do it.

2

Hi @Sanghamitra_Sahoo,

More examples are needed to construct an algorithm by understanding the order.

Is the …_[letters][numbers].xlsx format always like this ?

Regards,
MY

3

Yes the filename will always be like this format, only the name and the number gets changed.
The number will always be in the last before .xlsm

4

Some example of other files :

D:\Users\u326509\Documents\UiPath\CSOD_OfferLetter_RE_3\InputFiles\Daron Fillip_req5636.xlsm

D:\Users\u326509\Documents\UiPath\CSOD_OfferLetter_RE_3\InputFiles\Deman Emily_req5591.xlsm

D:\Users\u326509\Documents\UiPath\CSOD_OfferLetter_RE_3\InputFiles\Elsie Soenen_req5364.xlsm

5

I hope it works for you.

extractData.xaml (5.8 KB)

Regards,
MY

6

@Sanghamitra_Sahoo

Try this -

Input_variable = system.text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension("D:\Users\u326509\Documents\UiPath\CSOD_OfferLetter_RE_3\InputFiles\Vigneron Christophe_req5658.xlsm").ToString,"[\d]+").ToString
7

@Sanghamitra_Sahoo

Check this implementation-

Screenshot (142)
Screenshot (142)826×492 17 KB

8

this expression will give you the output all the matched digitis…

9

@Sanghamitra_Sahoo Try this expression in the regex [\d]{4}[.] and replace the ". ",

Thanks,
Guna.

10

@Kotla_Gunasekhar

Numbers are dynamic it will be of 4 digits or less than it .
Its not a good approach for static regex for 4 digits.

11

This Works!! Thanks!! :slight_smile:

12

Hey @Sanghamitra_Sahoo

Take a look here at this 2min tutorial.

13

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