0

NL Binary Text

Jet Reports Historic Posts

June 03, 2015 09:44

None

Follow

Is it possible to format the output text to have line breaks, it is putting all the data in one long row of text

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts June 03, 2015 16:08

  Hi ColleyV
  
  I wanted to explore this but I'm trying to find a field in my database that is binary text. What field are you trying to pull?

• 0
  
  Jet Reports Historic Posts June 08, 2015 16:02

  It should respect carriage returns in the notes. Just setup the workbook with the Jet keyword Fit in the row and have it set to wrap text and it should work.
  
  Attached is an example.
  Book1.xlsx
• 0
  
  Jet Reports Historic Posts June 08, 2015 16:29

  One thing that I have found about Binary text in NAV is typically standard characters are interpreted correctly when pulling into Excel, but special characters may not.
  
  This is because NAV uses a different character set than what is being pulled in by Excel. This is a limitation of Windows, not Jet, however.
  
  So, as Jason mentions, it should respect carriage returns, it may have some unexpected results from time to time with the text in the database.

• 0
  
  Jet Reports Historic Posts June 08, 2015 17:03

  Here is a MSDN link about the character sets: https://msdn.microsoft.com/en-us/library/dn271702%28v=nav.71%29.aspx
  
  (NAV is using Unicode whereas Windows is using ANSI)