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|RegStFra c|RegStName|RegStType|RegUnitType|RegStPreDirection|RegStPostDirection|RegSt UnitNum|RegCity|RegState|RegZipCode|CountyCode|PrecinctCode|PrecinctPart|Leg islativeDistrict|CongressionalDistrict|Mail1|Mail2|Mail3|Mail4|MailCity|Mail Zip|MailState|MailCountry|Registrationdate|AbsenteeType|LastVoted|StatusCode 3593761|SUSIE||VOTER||1976-10-03|F|1233501||250TH|PL|#|NW||C108|KENT|WA|9803 0|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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/09e001d8da00%2451ccefb0%24f566cf10%24%40gmail.com.
