Hi Team,,, Yesterday I received raw data from Data feed in zip format. After extracting it, when I opened the file seeing "event_list" column is getting converted into "##########". not able to understand the content behind it. Please suggest here how to extract data from "############"
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
I believe this is just an Excel visual display, not an actual conversion of the content....
See https://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong
Can you open your raw data feed into a text editor? Notepad, Notepad++, TextEdit, etc
You should see the data as it actually is...
I believe this is just an Excel visual display, not an actual conversion of the content....
See https://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong
Can you open your raw data feed into a text editor? Notepad, Notepad++, TextEdit, etc
You should see the data as it actually is...
However, we can't play much in other editor than Excel.. any better way.. please suggest..
Views
Replies
Total Likes
Oh I get that, Excel is the tool for manipulating data, but you may have to try changing the data formatting to Text or General (to get it back), or as @Ankit_Chaudhary suggested, try and prevent Excel from converting the formatting to start with.
Views
Replies
Total Likes
During initial load excel ask to convert field type simply select don't convert any you might prevent this.
Views
Replies
Total Likes
Views
Likes
Replies