LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  FTP Get in Ascii mode

    Employee
    Posted 04-17-2018 23:12

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: newbie

    Hello, I am trying to FTP GET a file, but the file is in Binary format. How can I FTP get Ascii format so I can read it? thanks


  • 2.  RE: FTP Get in Ascii mode

    Employee
    Posted 04-20-2018 07:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi,

    There is no node property to specify the transfer type. If the file is text then you should be able to read the file even though the FTP transfer uses binary transport.
    What do you see if you open the file in, say, Notepad++ ?

    It may be that the file uses Unix style end of line characters (LF) rather than the Windows EOL (CRLF).

    Alternatively, you could try using the Delimited File node to import the data. In this case you could configure:

    a) the node's 'FieldDelimiter' property with a delimiter character that is unlikely to be present in the data e.g. the "�" character or the ASCII 'BEL' character "\x07" (in both cases without the quotes)
    b) the 'RecordDelimiter' property to the Unix EOL character "\n" (without the quotes)
    c) the 'FieldNames' property to a suitable name e.g. Data
    d) the 'File' property to the path of the downloaded file.

    This should at least allow you to run the Delimited File node and view the format of the data.

    Delimited_File_BEL_Char4.png