Regex Required to capture 2 tables

Help Robot
,
#21

This is one of those situations where you should look at your overall process. One of the issues I see in RPA is people simply automate bad processes instead of improving the process.

Where is that file coming from? The format is awful. You should work on that part of your overall process and get a better file.

#22

@postwick its a pdf file

#23

@prasath17 can this be done?

#24

Again, your data is not good…so this is the best I can get…

image
image776×496 20.2 KB

image
image1319×538 21.2 KB

#25

@prasath17 can u share this process?

#26

I know the data is aweful. The regex output seems good. LEt me work on it and then i will let u know.
Thanks @prasath17 for the help u r providing

1 Like
#27

It is a simple two step process.

Matches → Input is your string, Pattern is what I provided and Output is IEnRegex
For Each → Type Argument => System.text.regularexpressions.match
Write Line → Item.groups(1).tostring

#28

I got this. Its giving me only one word

image

#29

@rameezimtiaz - This is the Regex pattern…

(.+?)(?<FY1>[\d.,-]+(?=\s))\s*(?<FY2>[\d.,-]+(?=\s))\s*(?<FY3>[\d.,-]+(?=\s))?\s*(?<FY4>[\d.,-]+(?=\s))?\s*(?<FY5>[\d.,-]+)?\s*(?<FY6>[\d.,-]+)?
#30

Yes Sorry My mistake. I made a mistake and added a split function as well

#31

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