@ritikap3  

The issue you are facing is likely due to the way Pega handles file encoding and delimiters when storing and retrieving CSV files from Pega Cloud Storage using D_pxNewFile and D_pxGetFile. Here are some possible reasons and solutions:

Possible Causes & Solutions:

Missing Commas & Spaces (Flattened Data)

• Cause: When storing the file using D_pxNewFile, Pega might not be preserving the newline and delimiter characters properly, leading to a single concatenated string when retrieved.
• Solution:
  • Ensure that each field is properly enclosed in double quotes ("...") when generating the CSV content.
  • Use \r\n (carriage return + newline) for line breaks instead of just \n.

Encoding Issues

• Cause: The CSV file might be stored in an unexpected encoding format (UTF-16, UTF-8-BOM, etc.), causing it to lose formatting when retrieved.
• Solution:
  • Before saving the file using D_pxNewFile, explicitly set the encoding to UTF-8:

File Content Transformation by Pega Cloud Storage

• Cause: Sometimes, Pega Cloud Storage applies transformations to text files, stripping out formatting characters.
• Solution:
  • Instead of D_pxNewFile, try using pxGenerateExcelFile or pxGenerateCSVFile to create the CSV with proper encoding and formatting.
  • When retrieving the file using D_pxGetFile, verify the content type by checking the response headers.

Recommended Next Steps

1. Modify the CSV format: Ensure all fields are enclosed in double quotes and use \r\n for line breaks.
2. Explicitly set encoding to UTF-8 when storing the file.
3. Verify the retrieved file's format by opening it in Notepad++ or another text editor that displays encoding.
4. Use pxGenerateCSVFile instead of manually creating the CSV if applicable.

Hope this helps! Let me know if you need further assistance.