How to get line before and after specific line in text file

[anonymous3 (non)]

Hi all, I am currently working with a pdf copy of an invoice template and saving it as a .txt file to read. Anchor Base, Get Text, Get Full Text and Screen Scraping methods did not work for me when trying to read the specific area of text in the invoice.

I would like to know how I can get “11 Test Road” and “The Test Apartment” from the below example. Line 1, 3 and 4 are variables that change depending on the invoice. The only variables that do not change are “Person Address” and “Country”. What kind of string manipulation should I use?
Is Regex necessary for this?

[prasath17 (Guru)]

@anonymous3 - Please try the below Regex Patterns…

1. 11 Test Road

2. The Test Apartment

[NIVED_NAMBIAR (NIVED N)]

Hi @anonymous3
use this regex to extract the 11 Test Road
[\s\S]+(?=Person Address)

For extracting the the test apartment use below
.*(?=\nCountry)

[anonymous3 (non)]

Hi @prasath17 thank you for the quick reply. I am not familiar with regex in uipath studios, could I ask you to provide a screenshot or .xaml file to show how it looks like in studios?

[anonymous3 (non)]

Hi @NIVED_NAMBIAR thank you for the quick reply. I am not familiar with regex in uipath studios, could I ask you to provide a screenshot or .xaml file to show how it looks like in studios?

[ppr (Peter Preuss)]

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[prasath17 (Guru)]

@anonymous3 - Please find the starter help …Regex Pattern link

StrMatches is of Variable type : MatchCollection

Write Line: StrMatches(0).groups(1).tostring + vbcr +StrMatches(0).groups(2).tostring

Note: you can assisgn StrMatches(0).groups(1).tostring to get the 1st line and StrMatches(0).groups(2).tostring to get the apartment line…

Hope this helps…

[Pravin_Patil1 (Pravin Patil)]

@anonymous3

Welcome to the Community!

If the labels are going to change and the position is going to same then use below logic.

Considering varStr is your string

1. First line
   varStr.Split(System.Environment.NewLine.ToCharArray)(0)

2. Last second line
   varStr.Split(System.Environment.NewLine.ToCharArray)(varStr.Split(System.Environment.NewLine.ToCharArray).Length-2)

[anonymous3 (non)]

Hi @prasath17 ,

Thank you so much for your help! My process works with this

Cheers