Create/File listing: wrong output if field contains carriage return
Posted: Wed Dec 13, 2017 7:44 pm
XnView: MP 0.88 - 64 bit
OS: Windows 10 - 64bit
Browser mode: "Create/File listing ..."
Output the fields {Comment} or {IPTC:Caption}
If one of the fields contains carriage return/line feed, then the result will be more than one line per picture.
Effect:
Output format: Text or CSV => the import in Excel creates a wrong table structure
Output format: XML => the import in Excel works fine
To reproduce:
- take a picture, "Edit/Edit comment ...", create an Embedded comment (for example: XnViewMP<press Enter key>is<press Enter key>great)
or
- take a picture, "Tools/Metadata/Edit IPTC/XMP ...", input in the Caption field (for example: XnViewMP<press Enter key>is<press Enter key>great)
- "Create/File listing ..." with the fields {Comment} or {IPTC:Caption} and view the result
Proposed Solution:
Replace carriage return/line feed with a blank
OS: Windows 10 - 64bit
Browser mode: "Create/File listing ..."
Output the fields {Comment} or {IPTC:Caption}
If one of the fields contains carriage return/line feed, then the result will be more than one line per picture.
Effect:
Output format: Text or CSV => the import in Excel creates a wrong table structure
Output format: XML => the import in Excel works fine
To reproduce:
- take a picture, "Edit/Edit comment ...", create an Embedded comment (for example: XnViewMP<press Enter key>is<press Enter key>great)
or
- take a picture, "Tools/Metadata/Edit IPTC/XMP ...", input in the Caption field (for example: XnViewMP<press Enter key>is<press Enter key>great)
- "Create/File listing ..." with the fields {Comment} or {IPTC:Caption} and view the result
Proposed Solution:
Replace carriage return/line feed with a blank
Thanks to your detailed description I can reproduce