Error When Adding Csv (Tab Delimited) File As A Table In Ubot

[memeuu 12]

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

[pash 504]

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)

[memeuu 12]

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.

[pash 504]

 

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 >> save

try again

[memeuu 12]

open csv by notepad >> save as >> select encode to UTF8 >> save

try 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! 

[pash 504]

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.

[pablo322 1]

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

[pash 504]

 

hello, you can help me save the data in order?

 

look this

 

http://prntscr.com/bb1sr3

 

please post sample data. (not have image only)

[stanf 43]

quick question are you useing the large data plugin when creating your table?

[stanf 43]

here you go

you are going to need the large data plugin ( i think its free)

@ pash thanks for the regex

p.s thanx for the update to advanced video yestrday

the answer.ubot