Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 venkata praveen kumar pittala (venkatapraveen)
Coforge
Lead System Architect
Coforge
AU
venkatapraveen Member since 2013 4 posts
Coforge
Posted: Jul 8, 2018
Last activity: Jul 18, 2018
Posted: 8 Jul 2018 22:36 EDT
Last activity: 18 Jul 2018 3:24 EDT
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.

To see attachments, please log in.
Low-Code App Development
Data Integration

Posted: 6 years ago
Posted: 12 Jul 2018 5:27 EDT
Mounica Gudaboina (gudam)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

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!

To see attachments, please log in.
Posted: 6 years ago
Posted: 18 Jul 2018 3:24 EDT
venkata praveen kumar pittala (venkatapraveen)
Coforge
Lead System Architect
Coforge
AU

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_

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice