CSV with multiple character separator

Options
meryem
meryem Registered Posts: 1 ✭✭✭✭

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

Tagged:

Answers

  • AdrienL
    AdrienL Dataiker, Alpha Tester Posts: 196 Dataiker
    Options

    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).
Setup Info
    Tags
      Help me…