@Richard-Skinner ,
Rather than arguing with those who are trying to help you, why not provide better example data, for both “before” and “after” the transformation you want, that matches your description of the data, so that we have a better understanding of what you’re trying to achieve? Since your descriptions don’t match the example text, it’s rather difficult for us to come up with a regex that will work with your data. If column number is the important thing, then focus on columns in your description and example data; if the important thing is actually anything after the seven digits of ?id=7777777, then focus on that string and not column number. But insisting on 52 characters when your example data isn’t 52 characters long is … tiring.
Even though you haven’t shown that you understood or took my advice to heart, I’ll give you two guesses: one that assumes that the critical piece of information is 52 characters, and one that assumes that the id is the critical piece:
52 char
FIND = (?-s)^(.{52}).*$
Explanation: turn off .-matches-space, match beginning of line, match 52 characters and store in group 1, match remaining characters on line
REPLACE = $1
replace with contents of group 1 (so effectively deletes everything after the first 52 characters)
MODE = Regular Expression
ID
FIND = (?-s)(\?id=\d{7}).*
Explanation turn off .-matches-space, match ?id= followed by 7 digits and store in group 1, match remaining characters on line
REPLACE = $1
replace with contents of group 1 (so effectively deletes everything after the 7-digit ID)
MODE = regular expression
