Find number before a word

Hi Friends,

I am working on PDF automation where I have read the PDF text using ReadPdfText Activity and stored the text in a variable.
Now I have to sum up all numbers before a certain word.
For Example - "8348 COLLECTIONS @ 0.0000 = 0.0000 , 35 COLLECTIONS @ 1.0000 = 3500.0000, 1 COLLECTIONS @ 2.3500 = 4627.1500 For
20200229 - 20200306 "

from the above text I have to extract number before word ‘COLLECTION’ i.e. 8348 , 35 and 1 and have to sum all number so for above string the result I want is 8348+35+1 = 8348.

Please Help…

Try this:

Processusvierge.zip (11,9 Ko)

Thanks Brother :pray:

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