Thanks John. Ultimately using the LOAD command is what I've chosen to use. The data is somewhat jumbled in this case, but as long as it's consistently jumbled all will be well. Basically these files I'm dealing with are downloaded from a 3rd parties website. They're in a csv format, but they files really look as though they were originally xls files formatted for human readability, and then saved as a csv. So when I try to load the data, there are blanks all over the place, and generally speaking the data just isn't really in a columnar format.
Thanks again! Matthew Burke Pioneer Bank - IT Department Database Administrator 575-627-4415 Office 575-317-5889 Mobile 575-624-3389 eFax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo II Sent: Friday, December 14, 2012 3:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: GATEWAY IMPORT CSV with a LF only file At 04:54 PM 12/14/2012, Matthew Burke wrote: >Does anyone know if there's a way to do this with CSV files? I tried it >exactly as it is presented here, but no luck. At 04:57 PM 12/14/2012, Matthew Burke wrote: >I did try changing A B and C to Field1 Field2 and Field3 respectively, >as well. Matthew, The ADD_MAPPING parameter is only an available GATEWAY import option with the XLS format type. The CSV import type will not recognize the ADD_MAPPING parameter. Have you tried using the LOAD command to import the data? Best regards, John Minyo II Customer Service R:BASE Technologies, Inc. P: 1+724.733.0053 http://www.rbase.com http://www.facebook.com/rbase
