| |
|
|
Some data cells in the Excel spreadsheet have {/n} in them
This occurs when the Integra profile is set to Normal export. When exporting large amounts of text to a cell in Excel, Integra cannot export the text with the original carriage returns. The reason for this is that any carriage return has to be converted to {/n} when using Normal export.
Excel cannot replace the text {/n} to a carriage return character after the data has been imported to Excel. You can correct this behaviour by adding the following formula to the affected field:
@ReplaceSubstring(@Text(yourFieldName);@Newline;"; ");
The above will replace any carriage returns with a semicolon (or any other character of your choice). Should you need to export the carriage returns on Excel, you need to set your profile to use Advanced COM export instead of Normal export. |
. |
|
FAQ# 0201
|
|
|
| |