memeuu 12 Posted April 17, 2016 Report Share Posted April 17, 2016 I'm trying to add this google keyword planner csv file into ubot so I can use as a table. Attached to this post is the csv file I want to add to ubot. In ubot when I "create the table from csv file", the table data turns to unreadable characters and so its all messed up. If I open the csv file in notepad, I see that the data is separated by tabs rather than commas. So if I go to excel and save this csv file as a comma delimited txt file, then I am able to create the table from csv file in ubot. Is there a way to directly add the csv file (downloaded directly from google keyword planner) into ubot as a table,without converting it to comma delimited txt file? Thank you for helping.googlekeyword.csv Quote Link to post Share on other sites
pash 504 Posted April 17, 2016 Report Share Posted April 17, 2016 try. set(#MyData,$read file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv"),"Global") set(#MyData,$replace regular expression(#MyData,"\\t",","),"Global") save to file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv",#MyData) create table from file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv",&MyTable) Quote Link to post Share on other sites
memeuu 12 Posted April 17, 2016 Author Report Share Posted April 17, 2016 try. set(#MyData,$read file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv"),"Global") set(#MyData,$replace regular expression(#MyData,"\\t",","),"Global") save to file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv",#MyData) create table from file("C:\\Users\\Apichai\\Desktop\\googlekeyword.csv",&MyTable) Thank you for replying. I've tried your code, and it produce these unreadable characters as data in the ubot table.Please check my attached screenshot. I think this has something to do with the text encoding, maybe from google keyword planner csv file downloads. Quote Link to post Share on other sites
pash 504 Posted April 17, 2016 Report Share Posted April 17, 2016 Thank you for replying. I've tried your code, and it produce these unreadable characters as data in the ubot table.Please check my attached screenshot. I think this has something to do with the text encoding, maybe from google keyword planner csv file downloads.open csv by notepad >> save as >> select encode to UTF8 >> savetry again Quote Link to post Share on other sites
memeuu 12 Posted April 17, 2016 Author Report Share Posted April 17, 2016 open csv by notepad >> save as >> select encode to UTF8 >> savetry again This works, but is there anyway to do this within Ubot so that I don't have to download csv file from google, then use notepad to save as utf8, and then add to ubot. Thanks so much for your help. I really appreciate it! Quote Link to post Share on other sites
pash 504 Posted April 18, 2016 Report Share Posted April 18, 2016 This works, but is there anyway to do this within Ubot so that I don't have to download csv file from google, then use notepad to save as utf8, and then add to ubot. Thanks so much for your help. I really appreciate it! PM. Quote Link to post Share on other sites
pablo322 1 Posted June 1, 2016 Report Share Posted June 1, 2016 I'm trying to add this google keyword planner csv file into ubot so I can use as a table. Attached to this post is the csv file I want to add to ubot. In ubot when I "create the table from csv file", the table data turns to unreadable characters and so its all messed up. If I open the csv file in notepad, I see that the data is separated by tabs rather than commas. So if I go to excel and save this csv file as a comma delimited txt file, then I am able to create the table from csv file in ubot. Is there a way to directly add the csv file (downloaded directly from google keyword planner) into ubot as a table,without converting it to comma delimited txt file? Thank you for helping. hello, you can help me save the data in order? look this http://prntscr.com/bb1sr3 Quote Link to post Share on other sites
pash 504 Posted June 1, 2016 Report Share Posted June 1, 2016 hello, you can help me save the data in order? look this http://prntscr.com/bb1sr3 please post sample data. (not have image only) Quote Link to post Share on other sites
stanf 43 Posted June 1, 2016 Report Share Posted June 1, 2016 quick question are you useing the large data plugin when creating your table? Quote Link to post Share on other sites
stanf 43 Posted June 1, 2016 Report Share Posted June 1, 2016 here you goyou are going to need the large data plugin ( i think its free)@ pash thanks for the regexp.s thanx for the update to advanced video yestrdaythe answer.ubot Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.