Data Truncated or Mangled on CSV Export with Special Characters (>>> <<<, <, >)

[npatil]

Hello,

I'm experiencing an issue with SmartClient's CSV export functionality related to fields containing special characters (like >, <, etc.).

Description:

1. Original Data Format:
   In my table, one of the fields contains string data in the following format:
   
   "<test>newtest>>><<<<test>"
   
   
   
2. Exported CSV Output:
   When I use the export to CSV feature, the exported data in the corresponding field becomes:
   
   "newtest>>><<<"

Problem:
It appears that anything enclosed in angle brackets (<...>) is being stripped out or lost during the export process. The special characters > and < within the field are not handled correctly, resulting in data truncation.

Expected Behavior:
I expect the export to preserve the original string as-is (including any <, >, and other special characters), so the exported CSV field value should be:

"<test>newtest>>><<<<test>"
and not truncated or altered.

Question/Suggestion:

• Is this a known issue or intended behavior due to CSV exporting logic?
• Are there any workarounds or export options/settings to avoid this data loss?
• Can this be fixed or improved in a future release?

Any advice or solution would be appreciated!

[Isomorphic]

They are most likely being treated as HTML and you are set to ignore such tags. See the Export & Formatting overview.

[npatil]

Hi Team,
Is there any specific suggestion cause i checked i didn't found anything.