PDA

View Full Version : Splitting lines


swaring
April 14th, 2011, 05:00 AM
Is there a way that i can split the amount of words that is displayed on a line in fusion pro. Without editting it in Excel first. For example in one cell of my excel document, i have the text saying 'The lazy fox jumped over the traffic warden', is there a way in excel so that fusion pro splits the line up so we have 'The lazy fox' and one line and the rest on the second line. Need to split with amount of characters ideally. I know its a big ask but just wondered if it could be done rather than altering all of the excel file.

Hope you can help.

Thanks
Simon.

esmith
April 14th, 2011, 08:01 AM
I'm not sure I understand exactly what you are wanting to do (assuming you want the break to occur across multiple records for different strings), but you can likely create a JavaScript rule that returns the string from your data with added break tags (and checking the "return text as tagged" box in the rule dialog).

If the text was ALWAYS constant between records, your rule might look something like:
var result = "The lazy fox<br />jumped over the traffic warden";
return result;