Re: [libreoffice-users] Spreadsheet question

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