Question
2
Replies
164
Views
Incessant
Posted: July 8, 2018
Last activity: July 18, 2018
Closed
Excel Access newline becoming _x000D_ with MSOParseExcelFile
Excel Access newline becoming _x000D_ with MSOParseExcelFile.
System appending _x000D_ when there is a new line(Alt+Entr) in the column's data after parsing it to clipboard. Let me know if there is any solution other than replacing _x000D_ with newline function for each column.
Posted: 2 years ago
Using 7.3.0 PEGA version
We are using MSOParseExcelFile to parse the field
Steps to reproduce
1. Configure Excel template with a column
2. Provide sample data by in two with two lines using Alt+Entr
3. Use MSOParseExcelFile. its parsing into clipboard with line feed _x000D_
Hello Praveen,
Can you please let us know the following details:
1.Version of Pega used?
2. Design Configuration screen shot
3.Sample excel sheet which contains the new line.
Can you please elaborate on " Let me know if there is any solution other than replacing _x000D_ with newline function for each column."?
Are you referring to the replacement before upload or after upload?
Thanks!