Question
2
Replies
184
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.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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!