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


In Linux that are a number of option using standard 
commands.
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 <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.


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