C1Excel LoadCSV Carriage Return Issue

C1Excel LoadCSV Carriage Return Issue

Posted by: james on 2 March 2021, 4:00 am EST

• 

  james

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 March 2021, 4:00 am EST

  I have a CSV with a text qualifier of inverted commas " and with a comma , delimiter.
  
  If the CSV has a cell entry with a carriage return, then C1XLBook.Load method will place this on a new row.

  For example, if the CSV file is:
  
  Name, Address
  
  “James”, “1 James Street”
  
  “Peter”,“1 Peter Street
  
  PeterSuburb”
  
  “Joe”,“1 Joe Street”

  Then, xlsheet[1,0] is “James”, xlsheet[2,0] is “Peter”, and xlsheet[3,0] is “PeterSuburb”.

  But, if instead you open the CSV in Excel, save it as an XLSX, and then Load the XLSX with component one, it will have the behaviour I require, which is that the xlsheet[2,1] is
  
  “1 Peter Street
  
  PeterSuburb”.
  
  and xlsheet[3,0] is “Joe”.

  Is there anyway to tell the Load method of C1XLBook to treat the carriage return like Excel does, which if it’s within a set of inverted commas, then it is the same cell.
  
  Or is there another way within code to get my desired effect?

  Thanks

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 March 2021, 2:21 am EST

  Hi,

  Currently, this behavior can’t be achieved in C1Excel. We have escalated your requirements to the development team and will let you know when we have an update.

  Regards.
  
  Avnish.

  [Internal Tracking ID: C1WIN-24483]

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 June 2021, 7:44 am EST - Updated 3 October 2022, 11:10 pm EST

  Hi,

  This issue has been fixed in the latest 21v1 Hotfix release. Please update your C1 controls to the latest version. You can use the C1ControlPanel utility to update the controls to the latest Hotfix release as shown in the GIF attached.

  Regards.
  
  Avnish