Expand my Community achievements bar.

change the separators from commas (,) to semicolons (;) in datawarehouse export csv

Avatar

Level 1

Hello,

I sent a datawarehouse report in CSV format via SFTP. I received it, but the separator is a comma, and I want it to be a semicolon (;) instead. I don't see an option to change this. Could you please help me with this?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 2

@DouniaPal  Since Data export format is CSV i.e. Comma Separated Values that's why you will be receiving values as comma separated. There is no option available in Datawarehouse UI but you can once check with Client Care team if it is feasible from backend.

Avatar

Employee Advisor

Hey @DouniaPal Currently, I don't think is possible from the DW UI since the only exports are either CSV or Tableau which is mentioned in the documentation as well - https://experienceleague.adobe.com/en/docs/analytics/export/data-warehouse/dw-create-request/dw-requ...

Semi-colon isn't supported yet, but you can log this in the idea hub as a feature request.

Avatar

Level 2

@DouniaPal I agree with @AmanGu8 and @fhusain , there is no such feature yet introduced.