XML reads an entire file as one record, no line breaks / carriage return

Answers

• vaprog Member Posts: 1,157

  2017-05-22

  Hi,
  
  Don't process xml as a text file. Use an XMLPort or some Dotnet XML parser. XML does not need line breaks in order to mark-up records of a table.
  
  Your XML-file, if it has line breaks indeed, probably uses Unix style line breaks (<LF> only, rather than windows standard <CR><LF>). An XML parser is required to convert line breaks to this format anyway, so, why not store it this way in the file in the first place.

  0
• Village_Idiot Member Posts: 16

  2017-05-25 Answer ✓

  I have resolved this issue by setting a char limit/ length on the Integer table width. This seems to make sure that each row is cut off at 40.

  0
• Juhl Member Posts: 724

  2017-05-25

  Sounds like a bad idea.
  Use a parser...

  Follow me on my blog juhl.blog

  1
• EvR Member Posts: 178

  2017-05-26

  True, that's absolutely the worst idea. Don't treat XML like a glorified text file... Like so many have done in the past. Properly parse it as XML.

  0
• Village_Idiot Member Posts: 16

  2017-06-22

  The file is text, not XML.

  0
• Juhl Member Posts: 724

  2017-06-22

  Use xmlport

  Follow me on my blog juhl.blog

  0
• Village_Idiot Member Posts: 16

  2017-06-22

  i am doing that. the problem is solved

  0
• NavNab Member Posts: 181

  2017-06-23

  Village_Idiot wrote: »

  i am doing that. the problem is solved

  
  Hi Village_Idiot,
  
  I see that you already resolved your problem. But If you want to resolve it properly, then:
  
  1- Check your file with notepad++ (or equivalent). Show the special characters and see what is the return carriage on your file (CR, LF, CRLF ... or other)
  3- Check "RecordSeparator" property on your XMLport and set it to the adequate value from your file (By default it equals <<NewLine>>).
  
  The help says:
  
  
  

  0
• Village_Idiot Member Posts: 16

  2017-06-23

  nabil.bamoh@hotmail.com wrote: »

  Village_Idiot wrote: »

  i am doing that. the problem is solved

  
  Hi Village_Idiot,
  
  I see that you already resolved your problem. But If you want to resolve it properly, then:
  
  1- Check your file with notepad++ (or equivalent). Show the special characters and see what is the return carriage on your file (CR, LF, CRLF ... or other)
  3- Check "RecordSeparator" property on your XMLport and set it to the adequate value from your file (By default it equals <<NewLine>>).
  
  The help says:
  
  

  
  Thank you. You will notice in my very first post, I have written that I used notepad++ to check the file. and i did set record separators. Nothing worked until I set a limit on the record. It seems to work.

  0