Re: [libreoffice-users] Spreadsheet question

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 <msetzerii@gmail.com>
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"
> <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
>
>
> +------------------------------------------------------------+
>  Michael D. Setzer II - Computer Science Instructor
> (Retired)
>  mailto:mikes@guam.net
>  mailto:msetzerii@gmail.com
>  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: 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