Bill,
What is the TIME setting?
SHOW TIME
Make sure that connected database TIME SEQUENCE matches the input data.
SET TIME SEQUENCE HHMMSS
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak
At 07:58 AM 9/15/2020, 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
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/DM6PR15MB3530D87C15D62F71F4039177AA200%40DM6PR15MB3530.namprd15.prod.outlook.com.
--
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/0MfFlM-1k7lCn3bWU-00Om2f%40mrelay.perfora.net.
