How to change delimiter in the exported data in Hybris?

Question

I am exporting data from SAP Hybris. The data I am importing also has semicolons (;). In the exported data I see the delimiter is ; This is preventing me from splitting the data and do my work. Is there a way to change this delimiter to something else ?

I understand this can be achieved by changing the "csv.fieldseparator" property, but that would affect everywhere and I can't afford that in production.. Any suggestions would be appreciated

@SebastianCăşvean I am sorry I don't follow. Are you suggesting to surround the data with quotes ? I am exporting the data, do we have an option to add quotes around the data before exporting ? — Trishul Singh Choudhary, Feb 07 '20 at 17:12
My mistake, I'm sorry. I thought that you want to import data which contains ";". Do you use `hac` to export your data ? — user1234SI., Feb 07 '20 at 17:57
Ok and where do you use the exported data ? What is the problem with the ";" ? Don't you export it in a `.csv` file ? — user1234SI., Feb 08 '20 at 18:46
The issue is the data fields I export also has ; in it. So when I try to split the data and do what I need, I am facing issues. — Trishul Singh Choudhary, Feb 09 '20 at 04:44

score 2 · Accepted Answer · answered Feb 08 '20 at 23:08

2

Go to backoffice.
Search export.
In the advanced configurations set your new delimiter. By default, it is semi-colon (;).

answered Feb 08 '20 at 23:08

Farrukh Chishti

7,652
10
36
60

@TrishulSinghChoudhary: No worries man. If you found it useful you can accept my answer. Thanks. – Farrukh Chishti Feb 09 '20 at 11:21

How to change delimiter in the exported data in Hybris?

1 Answers1