CSV report is not splitting filters into different columns, just separated by commas. | Adobe Higher Education
Skip to main content
July 27, 2022
Répondu

CSV report is not splitting filters into different columns, just separated by commas.

CSV report is not splitting filters into different columns, just separated by commas.

 


 
Updating Media

 

Ce sujet a été fermé aux réponses.
Meilleure réponse par Jennifer_Dungan

Hi, your screenshot seemed to fail so we can't really see your example...

 

However CSV stands for "comma separated values". 

 

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

 

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

 

When I add "comma" as delimiter, the data preview now shows correctly:

 

1 commentaire

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 27, 2022

Hi, your screenshot seemed to fail so we can't really see your example...

 

However CSV stands for "comma separated values". 

 

Where are you attempting to open your CSV file? If you are opening it in Excel, do you have the correct column delimiters selected?

 

As you can see, in my Excel, "tab" is the current delimiter... so this isn't going to process a normal CSV properly:

 

When I add "comma" as delimiter, the data preview now shows correctly:

 

July 27, 2022

Appreciate it, I now was able to split them using your instructions. Thanks!

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 27, 2022

You're welcome 🙂