Brian, You said: o Go to Edit | Find & Replace... (or Ctrl+F). o Click More Options and tick "Regular expressions". o Search for $ and Replace with a single space. o Now search for USER: and replace with \n& .
When I put USER or CHANNEL in the 'Search for' box, and replace with \n&, it's adding a space above the line where USER or CHANNEL occurs? I want it to append the line with USER or CHANNEL to the line above. Did I do this wrong? Linda On Tue, Nov 15, 2016 at 3:36 AM, Linda Hull <chalcedony6...@gmail.com> wrote: > Brian, > > Fantastic! This is what I needed! You are always so good! > > Thank you! > > > Linda > > On Tue, Nov 15, 2016 at 2:53 AM, Brian Barker <b.m.bar...@btinternet.com> > wrote: > >> At 01:08 15/11/2016 -0500, Linda Hull wrote: >> >>> I[...] have Open Office 4.1.2. >>> >> >> With a free product, there is rarely any reason to stick with older >> versions. >> >> What I want to do is prepare the file using Open Office Writer, instead >>> of notepad++. >>> >> >> If you already have something that serves the purpose, why change? >> >> An example of the text is: >>> USER: nIckmenza ACCESS: 250 L >>> CHANNEL: #arlington AUTOMODE: OP >>> LAST SEEN: 0 days, 02:45:30 ago. >>> LAST MODIFIED: pomol Sir^POMOL!digi...@pomol.users.undernet.org 4087 >>> days, 09:31:38 ago >>> [etc.] >>> >>> What I want to do is make all of the data about each individual user be >>> on ONE line, so that it will open and appear all on a single line, in Calc. >>> [...] How can I do the same thing in Writer, to make the data for each user >>> in a single line? Like: >>> USER: okidoki ACCESS: 100 L CHANNEL: #arlington AUTOMODE: OP LAST SEEN: >>> 0 days, 17:27:17 ago. LAST MODIFIED: darxide dxd-!~ >>> d...@darxide.users.undernet.org 40 days, 07:29:15 ago >>> >> >> o Go to Edit | Find & Replace... (or Ctrl+F). >> o Click More Options and tick "Regular expressions". >> o Search for $ and Replace with a single space. >> o Now search for USER: and replace with \n& . >> >> You might find it useful to replace with a semicolon instead of a space >> in the first case. Then, when you use Paste Special... to paste the result >> into your spreadsheet, you can tick Semicolon under "Separated by" in the >> Text Import window in order to separate the text into different columns >> across the rows. >> >> I wouldn't mind knowing how to eliminate the colon ":" after USER: >>> AUTOMODE: SEEN: AND MODIFIED: without eliminating the colons in all of the >>> times? The >>> obvious way is Find and Replace each one R: E: N: and D:, is there a >>> more efficient way, maybe a regex for letters not numbers? >>> >> >> Yup. If the relevant colons are the only ones that appear after >> alphabetic characters instead of digits, search for ([:alpha:]): and >> replace with $1 (again with "Regular expressions" ticked). >> >> With your data in the spreadsheet, you may find Data | Text to Columns... >> useful in reformatting it. >> >> I trust this helps. >> >> Brian Barker >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> >