Skip to main content
Participating Frequently
Nov 16, 2023 11:04 AM UTC
Question

Is there any way to provide the row delimiter (like @.^) in 'Export Data Store Entity to csv' smart service ?

Need more customization in the csv file, I want to specify the row delimiter as @ or ^ specifically in the csv.

8 replies

stefanhelzle0001
Brainy
Nov 16, 2023 12:18 PM UTC
Participating Frequently
Nov 16, 2023 12:30 PM UTC

Thanks Stefan, 

That blog talks about the field separator , we have requirement where we need to specify the row separator as @ or ^, because my table content already have the data with \n (new line character) which is creating a problem while identifying a row in the csv, because the default row separator is also a new line character (\n).

stefanhelzle0001
Brainy
Nov 16, 2023 12:34 PM UTC

You cannot change that. Are you sure that CSV is a good format to manage this kind of data?

annap0005
Participating Frequently
Nov 16, 2023 12:45 PM UTC

CARET option is available in CSV delimiter input parameter.

Participating Frequently
Nov 16, 2023 12:53 PM UTC

Thanks Anna for your reply.
That parameter is for field separator not for row separator.

annap0005
Participating Frequently
Nov 16, 2023 2:00 PM UTC

afaik we do not have such thing..