Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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

2 Replies

Avatar

Correct answer by
Community Advisor

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

 

Avatar

Level 1

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