Default quoting style for CSV files

Solved!
dcarva23jnj
Level 2
Default quoting style for CSV files

Hi Community,

Is there a way to change the default quoting style for CSV files?

For example from "Excel style" to "Unix style". 

Thanks!

0 Kudos
1 Solution
AlexandreD
Dataiker

Hi @dcarva23jnj , thank you for clarifying. ๐Ÿ™‚

Currently there is no way to enforce the "Unix style" on all CSV datasets. When you upload a CSV file, DSS guesses the parameters which fit the file. If the guessed quoting style does not match what you expect, it is still possible to fix it in the "Preview / Format" section of the dataset settings.

I hope this clarifies better this time.

Kind regards,

Alexandre Dumont

Alexandre Dumont

View solution in original post

0 Kudos
3 Replies
AlexandreD
Dataiker

Hello,

Yes, it is possible to change the quoting style for the CSV file. Just create a dataset by uploading your CSV files, then open the dataset and go to "Settings", then "Format / Preview".

Screenshot_2021-03-16 lotr - Settings Dataiku.png

For more information, please see the dss documentation.

I hope this helps. Have a nice day!

Alexandre Dumont

Alexandre Dumont
0 Kudos
dcarva23jnj
Level 2
Author

Hi @AlexandreD 

Maybe I didn't explain myself properly.

My question is that, if by default, we can change CSV files to be assigned with Quoting Style "Unix style".

Best regards,

0 Kudos
AlexandreD
Dataiker

Hi @dcarva23jnj , thank you for clarifying. ๐Ÿ™‚

Currently there is no way to enforce the "Unix style" on all CSV datasets. When you upload a CSV file, DSS guesses the parameters which fit the file. If the guessed quoting style does not match what you expect, it is still possible to fix it in the "Preview / Format" section of the dataset settings.

I hope this clarifies better this time.

Kind regards,

Alexandre Dumont

Alexandre Dumont
0 Kudos