How to upload the pdf file based on the PO number

Help Activities
, ,
1

Hi Team,

I have a folder where all the pdf’s are downloaded.

Below is the sample filename

Purchase_Order_#600120642_642575.pdf

From the above filename i need to extract Po Number(600120642)from each file.

Thanks
Likitha

2

Hi @vinjam_likitha
Try using regex to extract PO number
image

I hope it helps!!

3

Hi @vinjam_likitha

1.Use For each file in folder
2.use Find matchings Patterns activity,Properties Panel
a.In the Pattern-(?<=#)\d+
b.Text to be searched in: CurrentFile.Name
c.Store the output in the variable
image

image
image1478×720 35.6 KB

Hope it helps!!