Regex to extract data including the nextline?

Here is my sample Data and format , yeah it has spaces I have extracted from pdf

08/11/2020          TEST HOME                    Mortgage Company                                                           TRU

then I use this regex (?<=^\s*\d{2}/\d{2}/\d{4}\s+)\S.*?(?=\s{2}) and then ignorecase and multiline

The output I wanted to get is TEST HOME MORTGAGE , but my current regex just gives me TEST HOME because MORTGAGE is on the next line.

Any idea guys ? would be appreciated. Thank you

1 Like

Hi @Jelrey,

Try to use regex for each and every line in the loop instead of entire data.

1 Like

Hi @Jelrey

The same type of query i have solved already. Below is the thread for the same

Have a look through it.

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

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