M
Martyn Lawson
Hi,
I am trying to insert Line feeds into a text box (that has been set to
accept paragraph marks) using rules.
I have a sharepoint list used as secondary datasource. This list has a field
called address which is a 'multiple lines of text' datatype. When the data is
brought in to InfoPath using a rule, the carriage returns are replaced with
spaces.
I have a solution working by modifying the sharepoint list to use a random
character for a carriage return, such as ? and then using the translate
function in Infopath to insert a CrLF using the information in
http://blogs.msdn.com/infopath/search.aspx?q=line+break&p=1
However, as you can appreciate this is not a very sophisticated solution as
the sharepoint list looks awful and this is intended to be used by other
solutions. Is it possible to use the translate function in this way? I need
to know what character sharepoint is returning and when it is converted to a
space.
I thought about changing the sharepoint list to have multiple address fields
and then use the concat funtion. However, since i would be inserting CrLfs
between them i could end up with blank lines if a particular sharepoint field
is empty.
Any help would be greatly appreciated.
Cheers,
Martyn...
I am trying to insert Line feeds into a text box (that has been set to
accept paragraph marks) using rules.
I have a sharepoint list used as secondary datasource. This list has a field
called address which is a 'multiple lines of text' datatype. When the data is
brought in to InfoPath using a rule, the carriage returns are replaced with
spaces.
I have a solution working by modifying the sharepoint list to use a random
character for a carriage return, such as ? and then using the translate
function in Infopath to insert a CrLF using the information in
http://blogs.msdn.com/infopath/search.aspx?q=line+break&p=1
However, as you can appreciate this is not a very sophisticated solution as
the sharepoint list looks awful and this is intended to be used by other
solutions. Is it possible to use the translate function in this way? I need
to know what character sharepoint is returning and when it is converted to a
space.
I thought about changing the sharepoint list to have multiple address fields
and then use the concat funtion. However, since i would be inserting CrLfs
between them i could end up with blank lines if a particular sharepoint field
is empty.
Any help would be greatly appreciated.
Cheers,
Martyn...