Guest Rob Jan Report post Posted 05/07/2004 07:42 AM Hi, I have a 500mb .csv file which has 6 million row, that look like this: "Blok A E","Rondweg","","20","A","","7611 BP","Aadorp","0546","852743" What I want to do, is to let people enter their telephone number in my voiceguide script, and then let voiceguide search for their telephone number in this database, extract the row and speak out some of the fields. THe phonenumber in the .csv file is separeted into two fields (9546 and 852743), so VOiceguide should somehow merge these two fields in it's search for the telephone number. Does anyone know how to do this? And will it perform (because of the size of 500mb), or should it ben in another database? Greetings, Rob Jan Share this post Link to post
SupportTeam Report post Posted 05/08/2004 06:29 AM You should import this file into a database, and have VG search through that database using the DB Query module. You should create another column in the database which would store the merged telephone number - this way the SQL query would only match against once column - not two. Make sure to set up indexes for the telephone number fields! Share this post Link to post
