Data Feed raw data column auto convert in Excel

Forum|Forum|1 year ago
May 17, 2024
2 replies
1026 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...

Jennifer_Dungan

Accepted solution

Community Advisor and Adobe Champion

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

Level 3

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

Jennifer_Dungan

Community Advisor and Adobe Champion

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.

Ankit_Chaudhary

Community Advisor

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded