CSV report is not splitting filters into different columns, just separated by commas. | Community
Skip to main content
July 27, 2022
Solved

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

  • July 27, 2022
  • 1 reply
  • 991 views

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

 


 
Updating Media

 

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

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 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
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 🙂