InfoPath Dev

Hi There, :)

What i want to acheive is:
Collect data from several separate feilds and insert them into single text box, on separate lines.

Simply using a rule with concat(feild1, feild2) works but i cannot add a carriage return, line feed in this way.

Any help would be appereciated :)

Hi GtUtHill and welcome to our forum,
XPath should support this, but I can't get it to work with special things lie #10. You could just put a function in code to do it. It may be that InfoPath prevents escaping via the Fx dialog.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Hi Patrick,

Thanks for your reply.
could you please post some sample function in code? I do not have a great deal of coding experience so some extra detail would be appreciated :)

Many Thanks
Greg Tuthill

Hi Greg Tuthill,
Here is the code sample to append text from two nodes into a third node with carriage return,

//Get Node1 value
var field1Value = XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text;

//Get Node2 value
var field2Value = XDocument.DOM.selectSingleNode("/my:myFields/my:field2").text

//Assign the combined text into the third node.
XDocument.DOM.selectSingleNode("/my:myFields/my:field3").text = field1Value + "\r\n" + field2Value;

Hope this Helps!

Agni
InfoPath Dev India

Thanks Agni!!

That works just fine!
:)

Greg

how to know is what myFiel is TextBox or DropDownList

Landolsi
Developpeur .NET
Developpeur Php

skype : mlaipsorg

If you are not that comfortable with script (like me!)
You can use rules.

create an xml file which consists of the following:

<?xml version="1.0" encoding="UTF-8"?>
<characters
cr="#xD;"
lf="#xA;"
crlf="#xD;#xA;"
/>

then add a recieve data connection to your form using the xml file. now you can use the carriage return on your formula builders by pointing to those fields.

ex. concat(field1, @crlf, field2)

Very cool response. Thanks Whapakk!

Patrick Halstead [InfoPath MVP]
InfoPathDev

Guys,

Don't forget the & inside the quotes:

Should read #
btw fantastic solution.

quote:

---

Originally posted by whapakk

If you are not that comfortable with script (like me!)
You can use rules.

create an xml file which consists of the following:

<?xml version="1.0" encoding="UTF-8"?>
<characters
cr="#xD;"
lf="#xA;"
crlf="#xD;#xA;"
/>

then add a recieve data connection to your form using the xml file. now you can use the carriage return on your formula builders by pointing to those fields.

ex. concat(field1, @crlf, field2)

---

There's another even better way to do this using eval. Check out last week's InfoPath Team blog entry:
http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx

This is a must-read post by David and Ned.

For some reason I could not get the XML file to work. However, using a text box formatted for paragraph breaks, read only, and set to not recalculate, I was thereby able to put in the formula box a CTRL+ENTER between two " which worked perfectly in the concat statement. (i.e concat(field1, Carriagereturn, field2)

I've just posted a problem with carriage returns in a form text box which is pulled from an access databased that does show the carriage returns. How do you get it to display the data as it is in the database?

Thanks

What do you mean by "Don't forget the & inside the quotes?" I cannot get this to work, but your message implies something else has to be added.

Disreard the question. We figured it out.
We needed an "&" in front of each encoded string.

i.e. crlf="#xD;#xA;" needed "#xD;#xA;"

quote:

---

Originally posted by lxhiss

Guys,

Don't forget the & inside the quotes:

Should read #
btw fantastic solution.

quote:

---

Originally posted by whapakk

If you are not that comfortable with script (like me!)
You can use rules.

create an xml file which consists of the following:

<?xml version="1.0" encoding="UTF-8"?>
<characters
cr="#xD;"
lf="#xA;"
crlf="#xD;#xA;"
/>

then add a recieve data connection to your form using the xml file. now you can use the carriage return on your formula builders by pointing to those fields.

ex. concat(field1, @crlf, field2)

---

---

Ah finally!

 

Seriously been strugling with this issue for hours to make it work, i thought i had tried everything.

 

This worked like a charm, thank you very much for this simple solution.

It looks like this doesn't work if you're using Forms Services and hosting the text box in a browser form. I'm unable to check the "Paragraph breaks" in the display. Does anyone have any other suggestions on how I can get this to work?