How to use "$" as delimiter when export data as CSV

Hi All,

Currently, I'm working on exporting the data store entity to CSV. I tried to use the "Export DSE to CSV" smart service. and our requirement is to use the $ symbol as a delimiter. However, the smart service only supports the predefined list of delimiters. please refer to the below screenshot.

If I try to use other symbols, I get the following error.
"Invalid csv delimiter $. A CSV delimiter must be one of the following values: "TAB", "COMMA", "SEMICOLON", "SPACE",  "PIPE", "CARET" (APNX-1-4505-027)"

Is there a way to use different delimiter other than the predefined list?

Thanks

  Discussion posts and replies are publicly visible

Parents Reply Children
  • Hi Vishnu,

    Both options are not working. I tried with Dollar_Sign and also constant. Both options return the following errors.

    For Dollar_Sign, Get the following error.

    Invalid csv delimiter Dollar_Sign. A CSV delimiter must be one of the following values: "TAB", "COMMA", "SEMICOLON", "SPACE", "PIPE", "CARET" (APNX-1-4505-027)

    For constant, Get the following error

    Invalid csv delimiter $. A CSV delimiter must be one of the following values: "TAB", "COMMA", "SEMICOLON", "SPACE", "PIPE", "CARET" (APNX-1-4505-027)

    Thanks