Data360 Analyze

 View Only

  • 1.  Import flat file with no delimiter in data360

    Posted 11-30-2020 10:41

    In LAE I was able to import a flat file using the Delimited File Node by using the \n for field delimiter and \n as record delimiter - then declaring one field name = Data. 

    I can't find another import data node that will do the same.  When using the CSV/Delimited Input Node, it errors as  "The delimiter cannot be a line break."

    Can you please tell me how to import this data?  Sample pulled into Notepad ++

     

     



  • 2.  RE: Import flat file with no delimiter in data360

    Posted 11-30-2020 23:20

    FieldDelimiter is optional, when left blank then CSV/Delimited Input Node works fine.



  • 3.  RE: Import flat file with no delimiter in data360

    Employee
    Posted 12-01-2020 02:41

    You can use the CSV/Delimited Input node to import the data. The FieldDelimiter property can be set to any character that does not occur in the data (in the example below it is set to the ASCII character x07 - BEL). The FieldNames property is configured with the single field name 'Data'. You may also want to set the QuoteCharacter property to a character value that does not appear in the data (set to the Not Sign character '¬' in this example) to ensure that any mis-matched double quote characters do not cause errors.