Good afternoon, all.
We often get requests to view large amounts of submitted Forms content as an Excel file; our usual method of doing this is to insert the Forms content into metadata templates within a repository, then use Export -> List Contents in Laserfiche Web Access to generate the file.
However, we're encountering a problem with longer free-text fields:
If the submitter enters a comma into such a field, it will count as a field delimiter when exporting the list contents if "comma" is selected as the delimiter character, "breaking" the resulting Excel. Selecting Tab as the delimiter prevents this with shorter free-text fields.
Unfortunately, if the free-text field is longer (e.g. a multi-line Forms input), we find that a paragraph break is interpreted during export as a Tab character...again "breaking" the resulting Excel file.
Is there any way to prevent line/paragraph breaks from being interpreted as Tab characters when performing an export of this kind?