Quick database rip



  • Hello I am on windows using the latest notepad + +. i have a database file that is in a specific order like it is below i ripped the data out for privacy reasons anyway i can just have everything removed but the hash ID every hash ID is the same length 32 characters long and can include numbers letters and capital letters would really hate to search each specific string 1 by 1 then manually delete the after math.

    IPHERE | DATE: | HWID: | password: | audioid: | hashid : |

    to explain abit about the database whee IPHERE is it shows the users IPv4 or v6 the date shows the date they uploaded the content including time stamp with am/pm the HWID shows their hardware ID for the white list and the password shows heir password for the white list the audioid shows the asset ID (in numbers) that they uploaded and the hashid is the audios asset IDs server hash.



  • i used box selection (alt + click and drag) to do it not as efficient if there was a simpler way to do it still looking for a solution thought as ill have many more of these



  • Hello @xavier-xenoph,

    It’s not very clear what you want to achieve, but, to my mind, you would like to change all records of your database file :

    IPHERE | DATE: | HWID: | password: | audioid: | hashid : |
    

    as :

    | hashid : |
    

    Am I right about it ?


    If so :

    • Open your database file, in N++

    • Open the Replace dialog ( Ctrl + H )

    SEARCH (?-s)^.+(?=\|.+\|$)

    REPLACE Leave EMPTY

    OPTIONS Wrap around and Regular expression ticked

    ACTION Click on the Replace All button


    Notes :

    • As usual, the (?-s) modifier means that the dot ( . ) matches a standard character, ONLY and NOT any *line-break character

    • Then the part ^.+ represents the longest range of characters of any line, but…

    • ONLY IF the condition, in the look-ahead, ( (?=\|.+\|$) ) is true. That is to say if it’s followed by two | symbols, with some characters between, ( \|.+\| ), which end each line ( $ )

    • Note that the | symbol have to be escaped as \|, to be interpreted as literal, as it’s a special regex character, too !

    • Due to the empty replacement zone, the selected range, of each line, is simply deleted

    Best Regards,

    guy038


Log in to reply