Regex help- large file

Help Studio
, ,
1

Hi Buddies,
'I have one big text file ,from which i want to extract one whole line from regex,
can you please help ,
Thanks in advance.
Here is an example…from this i have to extract the highlighted line only, the row, total purchase always remain same

This image shows a detailed financial report including transactions, settlement amounts in NZD, and reconciliation totals. (Captioned by AI)
This image shows a detailed financial report including transactions, settlement amounts in NZD, and reconciliation totals. (Captioned by AI)1362×864 19.8 KB

2

Hi @Anjali_Rani

Could you send the Input Text, so that we can give an accurate answer?

Here is the Regex you could try:
TOTAL PURCHASE .*(?=\nNET PURCHASE)
or
TOTAL PURCHASE .*

2 Likes
3

Hey @Anjali_Rani
If the line you’re trying to extract always starts with TOTAL PURCHASE, you can use a simple regex like this:
^TOTAL PURCHASE.*$

A regular expression tool highlights a match that identifies a line starting with "TOTAL PURCHASE" followed by any characters till the end of the line in the test string. (Captioned by AI)
A regular expression tool highlights a match that identifies a line starting with "TOTAL PURCHASE" followed by any characters till the end of the line in the test string. (Captioned by AI)932×537 21.7 KB

4

Not working for me :frowning:

The image shows a RegEx Builder tool with test text and a Regular Expression set to match lines starting with "TOTAL PURCHASE" followed by any characters, with the IgnoreCase option checked. (Captioned by AI)
The image shows a RegEx Builder tool with test text and a Regular Expression set to match lines starting with "TOTAL PURCHASE" followed by any characters, with the IgnoreCase option checked. (Captioned by AI)1177×757 22.6 KB

6

Thank you so much, It worked :smiley:

1 Like
7

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