Awesome, much appreciated.. Files are in your mailbox.
Frank Taylor - Director of Information Technology F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 Email: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, March 17, 2015 12:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Import CSV and DATETIME At 10:11 AM 3/17/2015, Frank Taylor wrote: >Oops, I had to go back to my code to look at it.. When the import, the >exported file also contains the line number in the delimited column, so >I have to import as Text, then I do an update that removes the line >number from the column using a SGET(importdatetimecol,17,1)) Now I am >trying to take that column that where I took out the logline number and >convert it to datetime Frank, You should be able to do all that in one step! Send me the sample CSV file along with table structure and I'll show you how to automate the entire process of importing CSV file in R:BASE. You have my private e-mail address. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
