Hi @daniel-lysk, @michael-vincent, @ekopalyse and All,
An other useful little trick :
Let’s imagine that our previous table has the size file values left justified, as below :
ACP5191 *PGM CBLLE 5120000 RELEASEID: ITI 19.045.004 06/12/15 14:12
ADS0130 *PGM CBLLE 3137536 VERSION 9.0.1 02/20/17 14:00
ADS0910 *PGM CBLLE 18124800 VERSION 10.1.5 02/11/20 00:38
GUY0000 *PGM CBLLE 123456789 RELEASEID: ITI 3.020.074 08/15/17 10:30
Now, in order to get the same values right justified, move the caret right before the left-justified numbers and note its column number C, in the status bar. Then, use the number C-1 in the regex S/R, below :
SEARCH ^.{42}\K(\d+)(\x20+)(?=\x20)
REPLACE \2\1
Click on the Replace All button
And… voila ! Even, if you have 1,000,000 records, it would have been the same !
ACP5191 *PGM CBLLE 5120000 RELEASEID: ITI 19.045.004 06/12/15 14:12
ADS0130 *PGM CBLLE 3137536 VERSION 9.0.1 02/20/17 14:00
ADS0910 *PGM CBLLE 18124800 VERSION 10.1.5 02/11/20 00:38
GUY0000 *PGM CBLLE 123456789 RELEASEID: ITI 3.020.074 08/15/17 10:30
Note that the regex S/R, below, does the opposite. It left-justifies the size files. So you get, again, the original file !
SEARCH ^.{42}\K(\x20+)(\d+)(?=\x20)
REPLACE \2\1
Cheers,
guy038