Data Feed raw data column auto convert in Excel

Forum|Forum|1 year ago
May 17, 2024
2 replies
1025 views

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 "############"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jennifer_Dungan

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

Ankit_Chaudhary

New Participant

During initial load excel ask to convert field type simply select don't convert any you might prevent this.

Jennifer_DunganAccepted solution

New Participant

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

DineshRkumarAuthor

New Participant

However, we can't play much in other editor than Excel.. any better way.. please suggest..

Jennifer_Dungan

New Participant

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded