9 Type and Count Lines via Regex Notepad++

Question

First doubt:

How to convert a phone book that is in format:

1188888888
1288888888
3188888888
1187877766

for:

11988888888
12988888888
31988888888
11987877766

via Notepad++ regular expression?

Or maybe if possible in PHP, as I have to loop several files. In case it is possible to do this "batch" in Notepad and someone can explain me xD

Remembering that the DDD can change. The entire list is for cell phones, so you don’t need confirmation to know if it is or isn’t. It would just need regex to move the first 2 houses and add the 9.

I tried to do adventures in PHP Dom but it didn’t work very well, let alone using fopen... I even managed to print the cool result, but I can’t export the final value back to csv. If this is the case, I will do it via Notepad++ even. It is more laborious, but it seems to be a simpler solution.

If anyone knows of an app or easier way to do this...

2nd doubt After the 9 digit has been added, I need to add a semicolon and the line count, which looks like this:

11988888888;1
12988888888;2
31988888888;3
11987877766;4

And of course, the list is huge, so I would need it to be very conventional. If you can do both at the same time with just 1 regex, it would be even nicer :D

PS: Now that I noticed that the last line of all the files is blank. That is, if there are 5000 lines in the file, 4999 has numbers, the last one is not. Soon the count should break only where it has number, not to "break" the file formatting.

Could anyone do that? Thank you :D

MY "SOLUTION" IN PHP (is not functional because it does not save the result, only shows on the screen)

<?php
$row = 1;
$handle = fopen ("Lista (1).csv","r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $num = count ($data);
    for ($c=0; $c < $num; $c++) {
    $datanew = substr_replace($data, "9", 2, 0);
        echo $datanew[$c]. ";$row <br />\n";
        $row++;
    }
}
fclose ($handle);
?>  

But it only prints on the screen. I couldn’t get it to overwrite the file.

Answer 1

Notepad++/Column mode

With Notepad++ you can solve this problem in three steps.

1 - Add the 9, place the courses in the third character of the first line and activate the Edit>column mode menu or (ALT+C), in the dialog box type the 9 and of ok.

2 - Repeat step 1, but this time leave the cursor at the end of the line, instead of the 9 add a ;.

3 - Access the column mode again leave the cursor after the ;, in the dialog box mark the radio number to insert in initial number place 1 which will be the number of the first line and let increse by in 1, finally of ok.

PHP

With php it doesn’t change the logic much as the string looks well formatted, it can be done based on size.

substr_replace() is responsible for adding first the 9 in position 2 of the manipulated line. Another addition occurs in the character 12(end of string) where the ;, followed by the line number($linha_atual) e de um quebra de linha(PHP_EOL), tudo isso é concatenado em$archivalque é o conteúdo do no arquivo, ele é criado comfile_puts_contents()`.

<?php

    $csvs = glob('*.csv');

    foreach($csvs as $index => $nome){
        $linha_atual = 1;
        $arquivo_novo = "";

        $handle = fopen ($nome, 'r');
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $linha_modificada = substr_replace($data[0], '9', 2, 0);
            $arquivo_novo .= substr_replace($linha_modificada, ';'. $linha_atual 
                             .PHP_EOL , '12');    
            $linha_atual++;
        }
        fclose ($handle);
        file_put_contents('novo'. $index .'.csv', $arquivo_novo);
    }