Re: [libreoffice-users] Spreadsheet question

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.
=DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2))
In ae1 put D
In ae2 put
=TIME(INT(D2/100),MOD(D2,100),0)




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




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