Loaded the csv file with libreoffice and click on space and
other boxes and entered :.
That brings in columns A thru AB.
On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote:
From: "Rogier F. van Vlissingen"
<vliscony@gmail.com>
Date sent: Sun, 13 Mar 2022 09:05:56 -0400
Subject: Re: [libreoffice-users] Spreadsheet
question
To: David Lynch <dlynch1319ng@gmail.com>
Copies to: users@global.libreoffice.org
wow... I had never used that function before...
I am not quite there yet, however, but at least this is a path. Here
is an
example of one of the strings
Date:20220302 Time:1631 PM1.0:000 PM2.5:000 PM10:000 CO2:0010
HCHO:0.001
TVOC:0.000 >0.3DustNum:00000 >0.5DustNum:00000 >1.0DustNum:00000
2.5DustNum:00000 >5.0DustNum:00000 >10DustNum:00000
Using the expression as you wrote it, I get fields, like this:
Date 20220302 Time 1631 PM1.0 000 PM2.5 000 PM10 000 CO2 0010 HCHO
0.001
TVOC 0.000 >0.3DustNum 00000 >0.5DustNum 00000 >1.0DustNum 00000
2.5DustNum 00000 >5.0DustNum 00000 >10DustNum 00000 and then I could
name the columns and delete the columns with the variable names.
I will have to study that function... thanks.
On Sun, Mar 13, 2022 at 8:41 AM David Lynch <dlynch1319ng@gmail.com>
wrote:
On 13/03/2022 12:04, Rogier F. van Vlissingen wrote:
Var1: value1 Var2: value2 Var3: value 3 ... Var10: value10
Place the strings in column 1 than put
=REGEX($A1,"(?<=^| |:)[^ ]+?(?=:| |$)",,COLUMN()-1)
in column 2 and drag right for ten columns and down.
David Lynch
--
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/
+------------------------------------------------------------+
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
---- File information -----------
File: BRSmart128S_0302-0313_2022_RFvV_BR.ods
Date: 13 Mar 2022, 23:16
Size: 675913 bytes.
Type: Libre-sheet