batch file to find a word, extract 2 line above the word and write it in diffrent text file

Question

In my scenario i need to check my file (XXX.txt) for the word "SPOT". There will be few of SPOT word in the file.

Now i need a script to write the top 2 line of the "SPOT" word in a new text fine and name it as "done.txt".

EXAMPLE XXX.txt

dfsfs
clip_id HDX
title Setiap hari
type PROMO
end
clip_id HDQ
title Citra
type SPOT
end
clip_id HDX
title Ri
type PROMO
end
clip_id HDX
title sni
type SPOT

so i need to write "done.txt" as per below.

clip_id HDQ
title Citra

clip_id HDX
title sni

Please advise for script to do this.

Many thanks

Answer 1

Here's the solution in Powershell, Microsoft's cmd successor:

# variables that you need to set
$source = "C:\temp\superuser.txt"
$destination = "C:\temp\done.txt"

#region easier to understand for PS newcomers
$hits = select-string -Path $source -SimpleMatch "SPOT" -CaseSensitive
$filecontents = get-content $source

foreach($hit in $hits)
{
    $filecontents[$hit.linenumber-3] | out-file -append $destination
    $filecontents[$hit.linenumber-2] | out-file -append $destination
    "" | out-file -append $destination
}
#endregion


#region shorter version
$hits = select-string -Path $file -SimpleMatch "SPOT" -CaseSensitive -context 2

foreach($hit in $hits)
{
    $hit.context.PreContext | out-file -append $destination
    "" | out-file -append $destination
}
#endregion

Answer 2

I highly recommend JREPL.BAT - a hybrid JScript/batch utility that performs regular expression text replacement. JREPL.BAT is pure script that runs natively on any Windows platform from XP onward.

Assuming JREPL.BAT is in your current directory, or better yet, somewhere within your PATH, then, a simple command line one-liner efficiently solves your problem:

jrepl "^((.*\n){2})type SPOT$" $1 /m /jmatch /f xxx.txt /o done.txt

• The /M multiline option allows searches accross newlines.
• The /JMatch option prints only the replacement strings for matches

Since JREPL is a batch script, you must use CALL JREPL if you use it within another script.

Full documentation is available from the command line using jrepl /?. You may want to use jrepl /?|more to see the help one page at a time. I never use MORE because my cmd.exe console window is configured with a large output buffer that enables me to scroll up to see past output.