change the separators from commas (,) to semicolons (;) in datawarehouse export csv | Community
Skip to main content
DouniaPal
New Participant
Sep 17, 2024 2:40 PM UTC
Question

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

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

PD10
Level 2
Sep 18, 2024 4:14 PM UTC

@douniapal I agree with @amangupta21 and @farazhusain , there is no such feature yet introduced.

Translate
FarazHusain
FarazHusain
Employee
Sep 18, 2024 2:55 PM UTC

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-request-report-options

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

Translate
AmanGupta21
Level 3
Sep 17, 2024 2:52 PM UTC

@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.

Translate
Terms & ConditionsAccessibility statement

Loading footer...