Yes, that the direction I have to go. Thanks so much. It gets really hairy with some of the notations.
Like a variable for DustNum >0.3 (micron), that variable name became two columns, ">0"0 and "3DustNum" I will have to become a spreadsheet jockey (again) about 40 yrs later... On Sun, Mar 13, 2022 at 9:34 AM Michael D. Setzer II <[email protected]> wrote: > 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" <[email protected]> > Date sent: Sun, 13 Mar 2022 09:05:56 -0400 > Subject: Re: [libreoffice-users] Spreadsheet question > To: David Lynch <[email protected]> > Copies to: [email protected] > > 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 <[email protected]> > > > 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: [email protected] > > 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: [email protected] 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
