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

The spreadsheet I sent gave columns A thru AB, but some 
may not have separated exactly correct. Not knowing 
exactly what changes would be needed.
Started by inserting a row at top.

To convert date to an actual date field. In ad1 put B.
In ad2 put this formula to make a date.
In ae1 put D
In ae2 put

On 13 Mar 2022 at 9:05, Rogier F. van Vlissingen wrote:

From:"Rogier F. van Vlissingen" 
Date sent:Sun, 13 Mar 2022 09:05:56 -0400
Subject:Re: [libreoffice-users] Spreadsheet 
To:David Lynch <>

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

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:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.