Hello Randy,
Thank you for taking the time to help me with this! I did as you said, changed DELIMIT=|, and verified that it was the default. Then ran the command. This is what happened: R>GATEWAY IMPORT CSV voters22V2.txt CREATE WaVoters -ERROR- Missing the opening parenthesis (2778) -ERROR- WaVoters is an undefined table. (2038) -ERROR- WaVoters is an undefined table. (2038) Not sure what to think about all this. 😊 Gary From: [email protected] <[email protected]> On Behalf Of randyp ctags.com Sent: Thursday, October 6, 2022 10:03 PM To: [email protected] Subject: Re: [RBASE-L] - Importing Data From Text File Dear Gary, Try proceeding in consecutive steps: SHOW This will reveal your present settings. Delimit will be , SET DELIMIT=| You can use the SHOW command to see that it was changed GATEWAY IMPORT CSV WaRegVoters.TXT CREATE WaVoters This should import your file [WaRegVoters.TXT] as CSV using | as the 'comma'/delimiter. It will create a table named WaVoters, hopefully with 35 columns. After the file is imported, you can rename the imported columns [File1, File2, File3...File35] to the column names in your database. That will convert the datatype and length. The advantage of using | as DELIMIT is that commas in addresses will not scramble your data. Sometimes there are issues with the length of a column. All the best, Randy Peterson Blue Springs, Missouri _____ From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > on behalf of [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > Sent: Thursday, October 6, 2022 10:53 PM To: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > Subject: [RBASE-L] - Importing Data From Text File Hello All, I am trying to import data from a text file, but I can not make it work. The file is a Vertical Bar Delimited TXT file. The file is formatted into 35 columns of various lengths. There are approximately six million rows. I have tried using the Gateway utility and the Gateway Import command. The Gateway utility freezes when I select destination sources for each column. When I try importing using the command, It also freezes up. The only way out is for me to shut down RBase using the Task Manager. When RBase freezes up, I notice that the Task Manager shows that Rbase is active and is using 30% of the CPU and 800-900 MBs of memory. The file I am trying to import is from the State of Washington. It’s a list of registered voters. The file format is the only format they offer this data in. I have tried converting the file using Excel, but it’s too large. The first row of data is the column names. I have pasted the first two rows to show what the data looks like. I have changed the identifying data, so the data below is not a real person or place. StateVoterID|FName|MName|LName|NameSuffix|Birthdate|Gender|RegStNum|RegStFrac|RegStName|RegStType|RegUnitType|RegStPreDirection|RegStPostDirection|RegStUnitNum|RegCity|RegState|RegZipCode|CountyCode|PrecinctCode|PrecinctPart|LegislativeDistrict|CongressionalDistrict|Mail1|Mail2|Mail3|Mail4|MailCity|MailZip|MailState|MailCountry|Registrationdate|AbsenteeType|LastVoted|StatusCode 3593761|SUSIE||VOTER||1976-10-03|F|1233501||250TH|PL|#|NW||C108|KENT|WA|98030|KI|2403|2403.023|47|9|||||||||2004-05-17||2020-11-03|Active I have tried importing into an existing table with the same column names, length, and data type as the data file, and I have tried importing using the create a new table. Unfortunately, nothing seems to work for me. I am using RBase X.5 Enterprise Version 10.5.5.10818. Thank you, Gary Randall -- 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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/09e001d8da00%2451ccefb0%24f566cf10%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/09e001d8da00%2451ccefb0%24f566cf10%24%40gmail.com?utm_medium=email&utm_source=footer> . -- 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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112A0EC437E5BD0FF661257C75F9%40PH0PR11MB5112.namprd11.prod.outlook.com <https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112A0EC437E5BD0FF661257C75F9%40PH0PR11MB5112.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer> . -- 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/09f901d8da0e%24180c3480%2448249d80%24%40gmail.com.
