Welcome, Guest
Username: Password: Remember me

TOPIC: CSV Export - no new lines problem

CSV Export - no new lines problem 3 years 2 months ago #56512

  • ngeorgiev
  • ngeorgiev's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hello,

I want to parse an exported CSV survey data, but it does not contain new lines entered by the user.

I noticed that if I export a "VV survey file" then there are {cr} and {newline}, but I find the structure of the file hard to parse. I cannot understand how the individual entries are separated.

Do you have any ideas how can parse entered new lines by the user?

Greetings,
Nikolay
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56564

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5279
  • Thank you received: 289
  • Karma: 246
So you need a .csv file that contains all line breaks entered by the user?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56575

Mazi wrote:
So you need a .csv file that contains all line breaks entered by the user?

Yes, I believe this is what he means.

I am in the same boat as ngeorgiev since I wish to see where the new line breaks were inserted. For example, in the 'Huge Free Text' question type, I have users list items on separate lines, and I wish to be able to parse each line separately. As of now, when the CSV is exported, it will jam all of the text in one line with no breaks visible.
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56584

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5279
  • Thank you received: 289
  • Karma: 246
I think the line breaks are filtered at export so the only solution I can think of is to edit the source code or get the data from DB manually.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56590

Sounds good, I will try editing the source code.

I appreciate your help, Mazi!
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56592

  • ngeorgiev
  • ngeorgiev's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
@Mazi, yes - data with line breaks.
@Tony - if you implement a solution, can you please share it? Thank You very much!
The administrator has disabled public write access.

Re: CSV Export - no new lines problem 3 years 2 months ago #56595

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5279
  • Thank you received: 289
  • Karma: 246
tonybaroneee wrote:
Sounds good, I will try editing the source code.

I appreciate your help, Mazi!
Maybe you can add another filter option like "filter linebreaks"?

Please have a look at docs.limesurvey.org/How+to+contribute+ne...meSurvey+development

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.118 seconds
Donation Image