Extract specific String

Help
,
1

Hi. I brought all text from PDF file by UiPath activity,
and I want to use regex and extract these items;

1
1945Ɨ131 18.3 KB

In row, first item is index.
Second item, which is underlined, is product name.
Third item is quantity of product, and fourth is price per product.
Fifth item, which is underlined, is total price. Others are extra.

I need second item and fifth item.
If have any good idea, please share that. Thanks.

2

@ysshin.temp - Is it possible for you to share the text file?

3

@ysshin.temp - Please try thisā€¦

To extract the 2nd Item
image

To extract the 5th Item
image

4

Thanks, but upload image was just one of example.
For using RPA machine, I have to make common format to extract items.

Second, third, fourth, fifth, sixth(that is note for explanation, so it can exist/not exist) is variable.
Just First item(index) is constant.

1 VMWare vCenter Server 6 SupportSubscription 1 1,800,000 1,800,000
2 VMWare vSphere 6 Enterprise Plus SupportSubscription 6 2,150,000 12,900,000
3 VMWare vSphere 6 Standard SupportSubscription 6 390,000 2,340,000
4 VMWare vSphere 6 Standard SupportSubscription 6 6 390,000 2,340,000 ė¹„ź³ ė‚“ģš©ģž…ė‹ˆė‹¤. 2,340,000
100 VMWare vSphere 6 Standard SupportSubscription 6 6 100 100 2,340,000 ė¹„ź³ ģž…ė‹ˆė‹¤.

I attach the text of example again, so can you give good idea again?
Thanks.

5

for 2nd item
(?<=^\d{1,}\s).*?(?=\s\d{1,}\s)
for 5th item
[\d,]+\r

you can get string list like below

txt ā† source text

Assing Activity
pattern1 = ā€œ(?m)(?<=^\d{1,}\s).*?(?=\s\d{1,}\s)ā€
pattern2 = ā€œ[\d,]+\rā€

list1 = Regex.Matches(txt,pattern1).Cast(Of Match).Select(Function(m) m.Value).ToList
list2 = Regex.Matches(txt,pattern2).Cast(Of Match).Select(Function(m) m.Value).ToList

6

Hi @park363 - With all due respect, It didnt pick the value in the last rowā€¦amount we need to capture is 100 hereā€¦(As per the screenshot)ā€¦

image

I am still scratching my head to get this regexā€¦its very very trickyā€¦

Plus for the first pattern 4th and fifth row we need to capture up to 6 another tricky place

I came so close for the first pattern, but 5th line is not perfectā€¦check thisā€¦

image

7

Actually a simple split function in an assigm would do it.

8

Hiā€¦@moenk ā€¦ with what character you would split in this case? See the user requirement above ā€¦I am interested to see ā€¦

9

Its obivously seperated by spaces, so if you split, you grab 2nd, 3rd, 5th item from resulting array. Do this in a loop over an array of the lines, for this need split the entire thing by CrLf first of course.

10

@moenkā€¦ I am afraid It wonā€™t work ā€¦please look closely again for the 2nd element he askedā€¦it has so many spaces ā€¦see below

1 VMWare vCenter Server 6 SupportSubscription 1 1,800,000 1,800,000ā€¦

11

Sorry, you are right, so we have to split on ā€œSupportSubscriptionā€ first, but this makes it not so beautiful any more. Iā€™d look at the process now if there is another format available.

1 Like
12

I did not check last 2 lines.
It is very tricky.

13

Thanks for your help.

I will remain and save first item to fifth item with regex like this:
[0-9]+ [a-zA-Z0-9ź°€-ķž£ ]+ [0-9]+ ([0-9]{1,3},)([0-9]{1,3}) ([0-9]{1,3},)([0-9]{1,3})

Then, I will use your idea.
It is tiresome, but I donā€™t know how to extract at once.

Thanks for your help.

1 Like
14

Thanks for your help.

15

@ysshin.temp - If the 2nd string would have ended consistently like the first 3 rows, I think there is a possibility. Since it is ending with 6 followeup by another integer makes the pattern tougher.

1 Like
16

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