Bill, your EXAMPLE data does not match your Load definition.
On Tuesday, September 15, 2020 at 7:58:15 AM UTC-4 Bill Niehaus wrote: > > We have an ASCII file containing data including the runtime the data was > collected in columns 33-40. Runtime has data type TIME. > > Example of data: > 095-45 169-1 14.9 13.0 12.80 15:29:25 14.9 356 1767 442 H---------- > > When we read the ASCII data into an Rbase table with the following LOAD > command, we get data loaded but the runtime is NULL. > > LOAD impQlab FROM filename + > AS FORMATTED USING + > station 1 3, + > test 5 6, + > plotnum 8 10, + > sample 12 12, + > inwt 15 18, + > outwt 21 24, + > runtime 33 40, + > sugar 44 47, + > sodium 49 52, + > potassium 54 57, + > aminonit 59 62, + > flags 64 74 > > Is there a way to load Time data from an ASCII file? > > Thanks. > > Bill Niehaus > > > Bill Niehaus > Official Trial Manager > [email protected]<mailto:[email protected]> > Office: 218 236-4768 <(218)%20236-4768> > www.crystalsugar.com > > [https://www.crystalsugar.com/images/acsc_logo.png] > > [https://www.crystalsugar.com/images/fb.png] < > https://www.facebook.com/AmericanCrystalSugarCompany> [ > https://www.crystalsugar.com/images/linkedin.png] < > https://www.linkedin.com/company/american-crystal-sugar-company> > > 1700 North 11th Street - Moorhead - 56560 - MN > > > This message is confidential. It may also be privileged or otherwise > protected by work product immunity or other legal rules. If you have > received it by mistake, please let us know by e-mail reply and delete it > from your system; you may not copy this message or disclose its contents to > anyone. The integrity and security of this message cannot be guaranteed on > the Internet. > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/78d58a0d-38fb-4eca-a6d6-745937311b63n%40googlegroups.com.
