On 15 Aug 2022 at 19:33, Johnny Rosenberg wrote: From: Johnny Rosenberg <gurus.knu...@gmail.com> Date sent: Mon, 15 Aug 2022 19:33:15 +0200 Subject: Re: [libreoffice-users] "reverse solidus" not working in the find dialog box To: LibreOffice Användare <users@global.libreoffice.org>
> Den mån 15 aug. 2022 kl 13:38 skrev Michael D. Setzer II < > msetze...@gmail.com>: > > > In Linux that are a number of option using standard > > commands. > > > > I think he said he's on Windows, actually. > Yes, but mentioned that there are ways to add both tr and sed to windows. I also wrote a little cpp program that does the same thing. Compile with linux compiler runs with test 9 record file linux run time ./weird weirdmsg real 0m0.003s user 0m0.001s sys 0m0.001s windows run time ./weird.exe weirdmsg real 0m0.236s user 0m0.042s sys 0m0.097s compiled with a native windows cpp compiler and run with windows versus via wine might be close in time. Said his file has 3,500 records so running with that would give a better comparison. > > Kind regards > > Johnny Rosenberg > > > > First would be sed > > sed 's/ \[/\t/g;s/\]/\t /g' <fix-in > > > > fix-in contains > > test [ sjflsdkf] [ jflsjflsf ] > > > > output is: > > test sjflsdkf jflsjflsf > > > > or > > > > sed 's/\] \[/\t/g;s/\[/\t/g;s/\]/\t/g' <fix-in > > that would change ] [ to a single tab, and then single [ or > > ] to \t. > > > > Another option would be tr command. > > tr ']' '\t' <fix-in | tr '[' '\t' > > > > There are generally windows versions of both sed and tr, > > but would have to look. > > > > Another option would be a simple cpp program to > > preprocess data. > > > > If you send a real copy of data, could look at writing a > > program. Another user had a file that had 8884 lines of > > data for a month of data, and wrote a program to filter to > > one line for each day, with the max values for 24 fields. > > > > Well good luck. > > > > > > On 15 Aug 2022 at 16:04, Thomas Blasejewicz wrote: > > > > Date sent: Mon, 15 Aug 2022 16:04:44 +0900 > > To: users@global.libreoffice.org > > From: Thomas Blasejewicz <ny...@hb.tp1.jp> > > Subject: [libreoffice-users] "reverse solidus" not > > working in the find dialog box > > > > > Good afternoon from Japan > > > Actually, I have asked about this in 2018 and a number of things were > > > suggested. > > > Unfortunately none did solve the problem. > > > Problem: > > > I have a long file with about 3,500 lines (each line = item) looking > > like: > > > HKES [] /(n) xxxxxx/ > > > > > > where I would like to replace the "space[" and "]space" with tabs > > > so that I can import the file into Calc. > > > > > > However, working with Japanese Windows 10, Japanese keyboard etc. > > > NOTHING I tried so far > > > allowed me to enter a \t (=> THIS is supposed to be a backslash) as a > > > regular expression, telling > > > the computer to replace the space[ with a tab. > > > > > > Question: > > > Is there a trick telling the computer to replace any key sequence with a > > > tab? > > > > > > Thank you. > > > > > > > > > -- > > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > > Posting guidelines + more: > > https://wiki.documentfoundation.org/Netiquette > > > List archive: https://listarchives.libreoffice.org/global/users/ > > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > > +------------------------------------------------------------+ > > Michael D. Setzer II - Computer Science Instructor > > (Retired) > > mailto:mi...@guam.net > > mailto:msetze...@gmail.com > > Guam - Where America's Day Begins > > G4L Disk Imaging Project maintainer > > http://sourceforge.net/projects/g4l/ > > +------------------------------------------------------------+ > > > > > > > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy