Pulling info from text file

[NickBtheITguy]

I have several large text files that I am trying to pull certain information together so that it can be imported into another application. I've attached a small excerpt from one of the files to show what I'm trying to work with.

The output should be a text file that basically looks like:

8: 331086

9: 10457

10:

11: 32993

12: 111161

14:

15:

16: 18335

17:

18: 79525

19: 264366

I've used pdftotext to dump a PDF to the text file maintaining the format, otherwise everything is so out of order. I know how to open the file, read each line, and write it to another file. What I can't figure out is how to parse each line for the desired information. Some of the lines contain numbers that I don't need and I thought maybe a regular expression would work but I really don't understand using regular expressions.

tax1.txt

[enaiman]

You might be able to use this pattern on every line to get you the last 2 group of numbers:

#include <Array.au3>
$str = "16        Advertising ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~                                                                                    16                      18335."
$tt = StringRegExp($str, "(\d+\h+\d+\.)\z", 1)
_ArrayDisplay($tt)

It would be up to you to process this further.

[Malkey]

Try this.

Local $tt, $i, $sStr

$tt = StringRegExp(FileRead("tax1.txt"), "(?:.+~+\h+)(\d+\h*\d*\.*)(?:\v+|\Z)", 3)

For $i In $tt
    $sStr &= StringRegExpReplace($i, "(\d+)(?:\h*)(\d*\.*)", "\1: \2") & @CRLF
Next

ConsoleWrite(StringStripWS($sStr, 2) & @CRLF)
MsgBox(0, "Results", StringStripWS($sStr, 2))

[NickBtheITguy]

Thanks! I'm working with both suggestions to see what's going to work for this situation.