Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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

 


 
Updating Media

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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:

Jennifer_Dungan_0-1658954456607.png

 

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

Jennifer_Dungan_1-1658955031088.png

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor and Adobe Champion

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:

Jennifer_Dungan_0-1658954456607.png

 

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

Jennifer_Dungan_1-1658955031088.png

 

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