Currently when using the CSV Buffer to import, values with more than 250 charcters get cut:
if Length > 250 then
Length := 250;
Rec.Value := String.Substring(CurrentIndex, Length);
This should be changed to handle the values the same way they are handled in the Excel Buffer by writing and reading to or from a blob field.
write:
"Cell Value as Text" := CopyStr(Value, 1, MaxStrLen("Cell Value as Text"));
if StrLen(Value) <= MaxStrLen("Cell Value as Text") then
exit; // No need to store anything in the blob
"Cell Value as Blob".CreateOutStream(OutStream, TEXTENCODING::Windows);
OutStream.Write(Value);
read:
if ExcelBuffer."Cell Value as Blob".HasValue() then begin
ExcelBuffer.CalcFields("Cell Value as Blob");
ExcelBuffer."Cell Value as Blob".CreateInStream(RecInStream, TextEncoding::Windows);
RecInStream.ReadText(CellTextValue);
end;
