Funny complication. One of the variable labels is PM2.5, but in this case that became two columns, H, and I respectively, like this:
H I PM2 5 On Sun, Mar 13, 2022 at 9:27 AM Rogier F. van Vlissingen <[email protected]> wrote: > Awesome, thanks! > > I replicated that, and now I can just name the columns and the delete the > preceding columns with the variable names and I am in business. > > One of these babies is 11775 rows ;-) > > > > On Sun, Mar 13, 2022 at 9:18 AM Michael D. Setzer II <[email protected]> > wrote: > >> 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" >> <[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 >> >> >> +------------------------------------------------------------+ >> Michael D. Setzer II - Computer Science Instructor >> (Retired) >> mailto:[email protected] >> mailto:[email protected] >> 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 >> > -- 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
