none
.txt column delimiter for the Json file

    Question

  • Hi,

    I have only just started with some data factory training. I have lots of .txt files to import.  they look like this

    225 Example description 201525 178 description of container 500x310x310mm 75 2.55

    The original ones I trained with were csv's

          "format": {
            "type": "TextFormat",
            "columnDelimiter": ",",
            "firstRowAsHeader": true

          },

    I need to change the column delimiter to  tab-delimited  Currently its not working because my column delimiter is a comma. I dont know what I should change the column too. Any help would be greatly appreciated.

     Debbie


    Friday, September 28, 2018 7:33 AM

Answers

  • Hi Debbie,

    To change the column delimiter to tab-delimited, just replace 

    "columnDelimiter": ","


    as 

    "columnDelimiter": "\t"

    in your format json definition.

    Thanks.

    • Marked as answer by Debbie Edwards Friday, September 28, 2018 10:53 AM
    Friday, September 28, 2018 8:26 AM

All replies