Re: [libreoffice-users] Spreadsheet question

=Not clear on how you got that break down with my 
instructions I get A thru AB and here I transposed them 
to show. PM2.5 is in Column G not two.
Then had formula to convert date and time value. Moved




ADate


B20220302
03/02/22
\u201c=DATE(LEFT(AH2,4),MID(AH2,5,2),RIGHT(AH2,2))
CTime


D1631</div>04:31:00 PM</font>
\u201c=TIME(INT(AH4/100),MOD(AH4,100),0)
EPM1.0</div>


F0


GPM2.5</div>


H0


IPM10


J0


KCO2


L10


MHCHO


N0.001



OTVOC


P0


Q>0.3DustNum




R0


S>0.5DustNum




T0


U>1.0DustNum




V0


W>2.5DustNum




X0


Y>5.0DustNum




Z0


AA>10DustNum



AB0




On 13 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote:


From: &#160;"Rogier F. van Vlissingen" 
<vliscony@gmail.com>
Date sent:60;Sun, 13 Mar 2022 09:30:49 -0400</span>
Subject: ;Re: [libreoffice-users] Spreadsheet 
question
To: 0;"Michael D. Setzer II" 
<msetzerii@gmail.com>
Copies to:60;users@global.libreoffice.org


> 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 <vliscony@gmail.com>
> 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 <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:        &#160;          "Rogier F. van Vlissingen"
> > > <vliscony@gmail.com>
> > > Date sent:       60;      Sun, 13 Mar 2022 09:05:56 -0400
> > > Subject:        ;        Re: [libreoffice-users] Spreadsheet
> > > question
> > > To:        0;            David Lynch <dlynch1319ng@gmail.com>
> > > Copies to:       60;      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 &lt;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




-- 
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