data lost in knowledge with cvs and comma #12591

Closed
opened 2026-02-21 19:08:06 -05:00 by yindo · 2 comments
Owner

Originally created by @nicho2 on GitHub (Apr 7, 2025).

Self Checks

  • This is only for bug report, if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:)
  • Please do not modify this template :) and fill in all the required fields.

Dify version

1.1.3

Cloud or Self Hosted

Self Hosted (Docker)

Steps to reproduce

Hello,

i tried to vectorize a csv file in the knowledge base and i noticed all lines with a comma are cut and so not appared in the data base

file to test :

column1 first column;;;column4;column5;column6;
"val1.1 cat1";"val1.2 cat 2";"val1.3 cat3";val1.4;val1.5;val1.6;
val2.1;val2.2;val2.3;val2.4;val2.5;val2.6;
x;x;x;Applicable;sentence with a comma, here.;"AUM-5 ";
val3.1;val3.2;val3.3 here a sentence.;val3.4;val3.5;val3.6;
val4.1;val4.2;val4.3;val4.4;val4.5;val4.6;
val5.1;val5.2;val5.3;val5.4;val5.5;val5.6;
val6.1;val6.2;val6.3;val6.4;val6.5;val6.6;
val7.1;val7.2;val7.3;val7.4;val7.5;val7.6;
val8.1;val8.2;val8.3;val8.4;val8.5;val8.6;
val9.1;val9.2;val9.3;val9.4;val9.5;val9.6;
val10.1;val10.2;val10.3;val10.4;val10.5;val10.6;
val11.1;val11.2;val11.3;val11.4;val11.5;val11.6;
val12.1;val12.2;val12.3;val12.4;val12.5;val12.6;
val13.1;val13.2;val13.3;val13.4;val13.5;val13.6;

✔️ Expected Behavior

have all lines

Actual Behavior

Image

Originally created by @nicho2 on GitHub (Apr 7, 2025). ### Self Checks - [x] This is only for bug report, if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general). - [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [x] I confirm that I am using English to submit this report (我已阅读并同意 [Language Policy](https://github.com/langgenius/dify/issues/1542)). - [x] [FOR CHINESE USERS] 请务必使用英文提交 Issue,否则会被关闭。谢谢!:) - [x] Please do not modify this template :) and fill in all the required fields. ### Dify version 1.1.3 ### Cloud or Self Hosted Self Hosted (Docker) ### Steps to reproduce Hello, i tried to vectorize a csv file in the knowledge base and i noticed all lines with a comma are cut and so not appared in the data base file to test : column1 first column;;;column4;column5;column6; "val1.1 cat1";"val1.2 cat 2";"val1.3 cat3";val1.4;val1.5;val1.6; val2.1;val2.2;val2.3;val2.4;val2.5;val2.6; x;x;x;Applicable;sentence with a comma, here.;"AUM-5 "; val3.1;val3.2;val3.3 here a sentence.;val3.4;val3.5;val3.6; val4.1;val4.2;val4.3;val4.4;val4.5;val4.6; val5.1;val5.2;val5.3;val5.4;val5.5;val5.6; val6.1;val6.2;val6.3;val6.4;val6.5;val6.6; val7.1;val7.2;val7.3;val7.4;val7.5;val7.6; val8.1;val8.2;val8.3;val8.4;val8.5;val8.6; val9.1;val9.2;val9.3;val9.4;val9.5;val9.6; val10.1;val10.2;val10.3;val10.4;val10.5;val10.6; val11.1;val11.2;val11.3;val11.4;val11.5;val11.6; val12.1;val12.2;val12.3;val12.4;val12.5;val12.6; val13.1;val13.2;val13.3;val13.4;val13.5;val13.6; ### ✔️ Expected Behavior have all lines ### ❌ Actual Behavior ![Image](https://github.com/user-attachments/assets/ea472fd1-b0a6-4fae-859a-87a688a69b16)
yindo added the 🐞 bug label 2026-02-21 19:08:06 -05:00
yindo closed this issue 2026-02-21 19:08:06 -05:00
Author
Owner

@dosubot[bot] commented on GitHub (Apr 7, 2025):

I found a similar unsolved discussion regarding CSV format document segmentation issues. You might find it helpful to check out the thread titled Help:CSV format document segmentation problem, which was last updated on August 8, 2024 [1].

In your case, it seems like the issue might be related to how the CSV parser is handling commas within fields. Ensure that your CSV file is properly formatted, with fields containing commas enclosed in quotes. This is a common requirement for CSV parsers to correctly interpret the data. If the issue persists, you might want to explore adjusting the CSV parsing settings or using a different delimiter if possible.

To continue talking to Dosu, mention @dosu.


Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other

@dosubot[bot] commented on GitHub (Apr 7, 2025): <!-- Answer --> I found a similar unsolved discussion regarding CSV format document segmentation issues. You might find it helpful to check out the thread titled [Help:CSV format document segmentation problem](https://github.com/langgenius/dify/discussions/7085), which was last updated on August 8, 2024 <sup>[[1]](https://github.com/langgenius/dify/discussions/7085)</sup>. In your case, it seems like the issue might be related to how the CSV parser is handling commas within fields. Ensure that your CSV file is properly formatted, with fields containing commas enclosed in quotes. This is a common requirement for CSV parsers to correctly interpret the data. If the issue persists, you might want to explore adjusting the CSV parsing settings or using a different delimiter if possible. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/115c6a5f-300d-4610-be4e-81799f87f9a6?feedback_type=other)</sup>
Author
Owner

@crazywoola commented on GitHub (Apr 7, 2025):

Please do not open duplicated issues. https://github.com/langgenius/dify/issues/17527

You can merge these into one issue instead.

@crazywoola commented on GitHub (Apr 7, 2025): Please do not open duplicated issues. https://github.com/langgenius/dify/issues/17527 You can merge these into one issue instead.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#12591