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
