CSV with multiple character separator

meryem
Level 1
CSV with multiple character separator

how to load a csv file with #:# as a separator into DSS :



 



0 Kudos
1 Reply
AdrienL
Dataiker

This is indeed not supported, only a single separating character can be used, either by directly specifying the character, or by specifying a unicode code point.



As a workaround, you can either




  • Define a custom format (requires writing a plugin); or

  • Use the "one record per line" format and then use a preparation recipe to split the lines into columns. You will have to specify the schema manually though (and skip the header line if you have one).