• [this new topic relates to https://wordpress.org/support/topic/full-image-where-used-export-list/#post-18983026 as the issue was encountered while testing the resolution of it]

    In various captions and other meta-fields we use ‘comma’, ‘double quote’ and even ‘intentional line feeds’ as “formatting elements” in the descriptions/captions, … … This causes issues when generating csv-files, where comma and double-quote are used to separate fields.
    This results in unexcpected – or rather unwanted – splitting/breaking of the records/lines in the csv file.

    Is there a handy way to overcome this issue? (other than reviewing all images in the media library to avoid comma and double-quote)

    I wonder whether the sequence of processing files into csv may be the root cause of the problem. In fact, if every ‘comma’, ‘double quote’, ‘linefeed-character’ – and maybe even some other, like ‘pipe’? – result in an additonal break in the csv-export, then we may have problems when importing of converting to excel…

    Hence the question: can such intentional use of ‘special characters’ be coded in such a way that csv would keep them only as ‘formatting elements within the separated field’ that would not result in ‘new line’ when converting in excel?

You must be logged in to reply to this topic.