Simple Text Formatting Question

[Former Community Member]

Hi, I'm having some difficulties with something I believe is simple, but I cannot get to work:



I have a text field for an address, and I am retrieving the address information from a database. This information comes in 5 lines (i.e. 5 different fields). In order to populate my address field with this data, I am using the "concat" function, but I cannot get it to show me the address in separate lines, so far I can only get it to show me a space between lines.

For Example:



I want it to show like this:

742 Evergreen Terrace

Springfield

USA

1X1-x1x



but it shows like this:

742 Evergreen Terrace Springfield USA 1X1-x1x



Does anybody know how to add a line break to the concat function?



Thank you.

[HowardTreisman]

Hi Daeveed

You can try the SetTextValue QPAC at:

http://www.avoka.com/avoka/qpac_library.shtml



You would use embedded XPath expressions in that like:

{$/process_data/@street$}

{$/process_data/@city$}

{$/process_data/@country$}

{$/process_data/@zip$}



This may solve your problem, although I havne't tested to see whether carriage returns are preserved when inserted into a form.



Howard

http://www.avoka.com