Posted by: rene1983 on 8 September 2017, 2:31 pm EST

  • Posted 8 September 2017, 2:31 pm EST


    Is there a correct/proper/universal rowDelimiter that should be used for LoadTextFile?

    Here is my code:

    fpSpread1.ActiveSheet.LoadTextFile(fileName, FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, "\r\n", "\t", "");

    I stated out using \n but that left a \r attached to the data in the last column so I changed it to the \r\n.  It seems to work, but I'm not sure it would work for everyone that uses my program.


  • Replied 8 September 2017, 2:31 pm EST


    There is no universal row delimiter as such. But you can refer to this link wherein even Scott has said that \r\n would work in most of the cases i.e. even with double quotes text. Here is the link for the same:- http://www.clubfarpoint.com/Forums/forums/thread/49660.aspx

    Hope this will help you. Thanks.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels