https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37879 Bug ID: 37879 Summary: Whitespaces mess with report results Change sponsored?: --- Product: Koha Version: 23.05 Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: infoscienceaddict@gmail.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl When a whitespace character (such as a space, tab, or line break) is accidentally added at the end of a subfield, it can cause issues in SQL reports. Specifically, it shifts all subsequent fields to the next columns, which disrupts the results. For example, if I select authid, 670$a, and 670$b from the auth_header table, and a space or tab has been added at the end of the 670$a subfield data in, say, the 3rd authority record, the resulting CSV will have an empty 670$b column. The data from 670$b will appear in the 1st column of the 4th line, the authid of the 4th record will be in the 670$a column, and so on. Therefore, would it be possible to add a tool or something that prevents catalogers from adding or pasting text that starts or ends with a whitespace character? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.