Addition to the last numbers

[Kiroptus]

Hello, sorry for my noobness about regular expressions but I need something as simple as just adding +25 to the final number. Its a big line but only the final 3 numbers that matter:

Example:

563474.7900 9698470.1500 4 MNH152.06@R00357
563415.4200 9698332.9000 3 MNH152.06@R00357
563365.9800 9698192.5000 2 MNH152.06@R00357
563315.6300 9698050.6800 1 MNH152.06@R00357

needs to become

563474.7900 9698470.1500 4 MNH152.06@R00382
563415.4200 9698332.9000 3 MNH152.06@R00382
563365.9800 9698192.5000 2 MNH152.06@R00382
563315.6300 9698050.6800 1 MNH152.06@R00382



There SO many files with that behavior, if anyone could help to find an expression to just replace the last 3 numbers (column 85, 86, 87) with +25 it would be extremely appreciated.

[ben_josephs]

Unfortunately, it isn't simple. Regular expressions can't count or add: all they know about is uninterpreted characters. In principle you can do this, but not with a single search-and-replace operation. It would be very tedious and would require many separate and different search-and-replace operations.

This is a job for a script in a suitable language, such as Perl, Python, Ruby, Tcl, ECMAscript or Lua. TextPad doesn't support scripts.

[Kiroptus]

Aw thats too bad, I thought it looked so simple. Thanks for the reply I will look into other ways of doing it.

[kengrubb]

If you have a spreadsheet program, that can handle more than 65K lines, it's easy enough with a Right Function.

Copy into the spreadsheet, write the Function, drag it down, copy and paste back into TextPad.

[jeffy]

If anyone could help to find an expression to just replace the last 3 numbers (column 85, 86, 87) with +25 it would be extremely appreciated.

You could do this easily in PhraseExpress:

Code: Select all

- zProcessAllLines:
{#LOOP zProcessLine -count {#INPUT -head How many lines to process? -single}}
- zProcessLine:
{#RIGHT -count 85}{#SHIFT {#END}}{#CLIPBOARD -copy}{#CALC {#CLIPBOARD -paste} + 25 -round 0 -thousands none}{#RIGHT}

Didn't actually try this, but you get the idea. As far as left-0-padding numbers that total less than 100, I think the CALC function may have some parameters to do so. And if not, the CALC function output could be inserted into a COND (conditional) phrase, which would certainly do the trick.

[jeffy]

Actually, if it truly is the last three characters, then this is better:

Code: Select all

- zProcessLine: 
{#END}{#SHIFT {#LEFT -count 3}}{#CLIPBOARD -copy}{#CALC {#CLIPBOARD -paste} + 25 -round 0 -thousands none}{#RIGHT}