Extract information

Question

I have long lines with information in a file. I need help to be able to search on specific information and extract only that part of the line.

The script need to work through a batch file, but I don't know if batch is the optimal language for this task.

Info.txt:

Time=20130101|Info=ok|Hello=1234321|Result=sunnyweather|Numbers=cow|File=hello.txt....
Time=20130532|Info=ok|Hello=78654321|Result=badweather|Numbers=horse|File=one.wav....

So I need to be able to extract for example the "Result=..." and export to another file.

Which scripting language would you propose and how?

Thanks on beforehand! :)

score 2 · Answer 1 · answered Jul 24 '13 at 13:43

2

you should use sed:

>echo("Time=20130101|Info=ok|Hello=1234321|Result=sunnyweather|Numbers=cow|File=hello.txt...."|sed -r "s/.*(Result=\w+).*/\1/"
Result=sunnyweather

sed for Windows.

answered Jul 24 '13 at 13:43

Endoro

37,015
8
50
63

score 1 · Accepted Answer · answered Jul 24 '13 at 15:08

1

How many lines do you have?

Hundreds:

If Exist Result.txt Del Result.txt
For /F "Tokens=4 Delims=^|" %%i In (Info.txt) Do Echo %%i>>Result.txt

Thousands or more:

Consider using SQLite shell (http://www.sqlite.org/sqlite.html).

answered Jul 24 '13 at 15:08

LS_ᴅᴇᴠ

10,823
1
23
46

Yes there are hundreds, how do i customize this script? Does Tokens=4 mean the forth section? – user2553264 Jul 25 '13 at 10:50
Yes. You may do `FOR /?` in command-line to see all FOR command options. What do you want to customize? – LS_ᴅᴇᴠ Jul 25 '13 at 10:54
Okey! Is it possible to count all `|` before a word of my choice? – user2553264 Jul 25 '13 at 11:55

Extract information

2 Answers2