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