Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index


Not sure if the utf-8 characters will go thru with this, but hopefully it does get 
thru in some fashion.

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 <nyuwa@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.


In looking at one line you gave. Have a program findnoascii to find utf-8 code and 
this is what I get.
line as I pulled from email (seems utf-8 character don't show with standard font).
HKES     [] /(n) xxxxxx/   

Results from my nofindascii 
     1      4 c2a0       [ ]
     1      6 c2a0       [ ]
     1      8 c2a0       [ ]
     1     11 e889af     []
     1     14 e79fa5     []
     1     17 e889af     []
     1     20 e883bd     []
     1     25 e3828a     []
     1     28 e38287     []
     1     31 e38186     []
     1     34 e381a1     []
     1     37 e3828a     []
     1     40 e38287     []
     1     43 e38186     []
     1     46 e381ae     []
     1     49 e38186     []

      3 c2a0       [ ]  NO-BREAK SPACE (U+00A0) 
      3 e38186     []   HIRAGANA LETTER U (U+3046) 
      1 e381a1     []   HIRAGANA LETTER TI (U+3061) 
      1 e381ae     []   HIRAGANA LETTER NO (U+306E) 
      2 e38287     []   HIRAGANA LETTER SMALL YO (U+3087) 
      2 e3828a     []   HIRAGANA LETTER RI (U+308A) 
      1 e79fa5     []   know, perceive, comprehend (U+77E5) 
      1 e883bd     []   "to be able; can, permitted to; ability (U+80FD) "
      2 e889af     []   good, virtuous, respectable (U+826F) 

using tr '[' '\t' <weirdmsg | tr ']' '\t' >weirdmsg.csv
get file that can be loaded in libreoffice weirdmsg.csv
Might want to change no-break spaces to a tab as well?


-- 
To unsubscribe e-mail to: users+unsubscribe@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:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.