My first thought is that this is not a "tab delimited" file. If you bring the file up in an ascii editor and cursor thru each character, a tab delimited file will "jump" to the next field when it hits the tab. I can cursor across the row one character at a time, so I'm not seeing any tabs in there. It's "almost" a fixed field file except that for some reason the "last 4" is off by 1 character.
I'd suggest you create a temp table that should hold each column of data and then use a simple "load" command rather than gateway, such as: LOAD <tablename> FROM <filename> AS FORMATTED USING <column1> 1 9, <column2> 18 25, <column3> 31 41 , etc...... When you get to the one-off column, just start the coordinates at the beginning of the leftmost one Karen -----Original Message----- From: 'jim schmitt' via RBASE-L <[email protected]> To: rbase group <[email protected]> Sent: Tue, Nov 17, 2020 12:01 pm Subject: [RBASE-L] - Import File Hi, Group: Need some assistance today. I have worked previously with Exporting files, but have not worked with Importing files. Now I have a potential new customer who wants me to Import data from another system. I have enclosed the tab delimited test file (only two records), but cannot get it to load. Using RBX5E. Test File attached. Do I need to set up a table in the database with the same names as in the test file ? Is this truly a tab delimited file ? Nothing seems to be working ?Maybe the file has Covid.... Any suggestions would be greatly appreciated. Thanks in advance, Jim-- 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/569365336.6619340.1605636079737%40mail.yahoo.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/79722105.6290223.1605637620878%40mail.yahoo.com.
