t Thomas
on

 

Hello,

Is there a way to add line breaks, or blank lines when populating the description column within the methods and comments tabs in the define.xlsx? 

For example, if I have the text "I would like a line break, or a blank line" as a comment, but I want it to come out in the define.xml as:

I would like a line break,

or a blank line

Thank you in advance for your help.

Tom

Forums: Define.xml

s Sergiy
on February 24, 2015

Hi Tom, 

Define.xml standard represents metadata. It's designed to store information only. Unfortunately no formatting including format specific characters (like <new line>) are available in "pure data".

Kind Regards, 

Sergiy

j Jozef
on February 25, 2015

Sergiy is right: XML is about data, not about presentation.
The presentation (including line breaks) is taken care of by the stylesheet.

There is a lot you can do in the stylesheet for presenting the data as you would like to see themin the browser (BTW, the stylesheet is the submittors responsibility, the one from CDISC is ONLY an examle). For example, it is pretty easy to define in the stylesheet that in any text longer than N characters, the dot at the end of a sentence must be translated into an HTML line break (<br/>). There are also many things you can do, like adding "instructions" in the define.xml itself, and then have these translated into presentation elements by the stylesheet.

You can always contact privately for more details.

l Lex
on February 25, 2015

I have seen people adding characters like "~" to their data, and let stylesheets replace those characters with an HTML linebreak (<br />). Please don't do that. When your data will be viewed outside of the stylesheet, or with a different stylesheet, you will suddenly see those strange characters in the data.  In case it is essential that the text is formatted, it is better to have a reference to a document witrh formatted text, such as a PDF document.

t Thomas
on February 25, 2015

Hello Both,

Thank you for your quick replies, your help is much appreciated.

Tom

t Thomas
on February 25, 2015

Hello Lex,

This is very useful information.  I'm working on creating a define.XML for an integrated database (close to 20 studies), so some of the derivations can be a bit long.  My initial recommedation to the team was to link to a pdf document or documents.  The team decided to use the cells available in the define (methods, comments, VL metatdata) as the place to hold the derivation text.  Your reply will save us a lot of time in making our decision.

Thank you!

Tom

l Lex
on February 25, 2015

Hi Tom,

I'm glad I could help. The great thing about Define-XML v2 is that you can define the metadata in the document references in such a way that the stylesheet can create links to specific pages or named destinations in a PDF file. In this way the link can go to the exact location in the document. You can just use one document for all the derivations. Such a document could be modeled after the Reviewer Guides as developed by PhUSE (http://www.phuse.eu/CSS-deliverables.aspx).

Lex

Want a demo?

Let’s Talk.

We're eager to share and ready to listen.

Cookie Policy

Pinnacle 21 uses cookies to make our site easier for you to use. By continuing to use this website, you agree to our use of cookies. For more info visit our Privacy Policy.