When exporting the paragraph field, it was exporting in a single line in a continuous manner. There is any way to export the paragraph field lines one by one as given in the input document.
Paragraph Field
Was this article helpful?
0 out of 0 found this helpful
Comments
5 comments
Hello,
Please specify what is export format do you use?
Thanks for the reply, excel was the export format.
Hello,
For line break character FlexiCapture uses LF (line feed), the same as in Excel. However, the problem with multi-line text occurs, because standard export to Excel just removes all line feeds. So, information about line break position is completely lost. But, you can use the following workaround.
I suggest you to create an auto-correction script for multi-line field(s) and replace line feed to combination or carriage return and line feed. As a result, on FlexiCapture data form line break will be still shown correctly (because of LF symbol), And in resulting Excel file the position of line break can be understood by CR symbol (LF will be removed). Then you have the following options:
1) Use Excel formula =SUBSTITUTE(<Cell reference>; CHAR(13); CHAR(10)) to replace “carriage return” to “line feed”. With this variant you don’t need any assistance from our side.
2) Automate the replacement process by “after export completed” event handler. In this case we will need to implement programmatic access to the export file (generated by standard export) from the handler and perform the replacement in all cells. This will be much easier than implement the whole export from scratch and can be done in just few hours. Up to one day in the worst case.
can you please give me an example to do;
create an auto-correction script for multi-line field(s) and replace line feed to combination or carriage return and line feed.
I did a small test writing a tiny code in desired field.
after i "recognize", value remain unchanged but has "..." button.
Once I press that button, vale canges
I do want to Auto-Export so how could I ??
thanks
I simply used following script and it worked for me:
string description;
description = Context.Text;
description = description.Replace("\n", "\r\n");
Context.Text = description;
Please sign in to leave a comment.