Hi Thomas,

Are you asking how to place a "hard return" or line break within a single cell in excel?
if yes, then use ALT + Enter. This works for google spreadsheets as well.

However, such hard breaks may not be visible in your the DSpace interface (surplus spacing may be ignored for display purposes and text wrapped), and even if  the data when exported to CSV has the line break. If you want data to display as separate lines, then you should enter them as separate values (using the double pipe as break) and then custom your theme to make these values display in single lines. 

For example, please see display of subjects here http://scholarship.rice.edu/handle/1911/64520

Apologies, if this has already been answered.

kind regards,

On 9/4/2013 8:47 AM, Thomas Ronayne wrote:
Hi, Helix84,

Thanks for that, but... I'm a little confused here.

I have to tell folks how to enter multiple lines in a spread sheet (they're mostly going to be using Excel, a few will be using OpenOffice Calc). That's the infrastructure and nothing I can do about that (when people volunteer to do work at home, you don't want to make it hard for them, you know?). I know that, on a Linux/Unix box, you can simply do Ctrl-V followed by Ctrl-L and there you go but what do they do in winders? Is <br> an actual pattern they can type that will actually do something or would I need to pass the CSV though sed to substitute that pattern with an actual Ctrl-L (not too clear on this point)? Gotta keep it as simple as possible.

If fiddling with XSL is needed, where do I do the fiddling? One of these:
cd /opt/dspace
find . -type f -name '*xsl*' | xargs fgrep -l 'disable-output-escaping'
I'm guessing structural.xsl might be a candidate (probably not though), where
<!-- Head metadata in item pages -->
            <xsl:if test="/dri:document/dri:meta/dri:pageMeta/dri:metadata[@element='xhtml_head_item']">
                <xsl:value-of select="/dri:document/dri:meta/dri:pageMeta/dri:metadata[@element='xhtml_head_item']"
and change that to "no" or "false" (and do I have to rebuild something after editing)?

Sorry, just a little confused about all this.


On 09/03/2013 04:18 PM, helix84 wrote:

Hi Thomas,

I know you won't like the approach, but literal newlines are preserved
if quoted. So this would be a valid one-line CSV with multiline value:

"first column","second column first line
second column second line"

However, the newlines will be lost when rendered by XSL. You may
however experiment with the disable-output-escaping in XSL to try to
render them literaly, or to render the <br> tag.


Compulsory reading: DSpace Mailing List Etiquette

Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!

Dspace-general mailing list