Paragraph number and H5 number equivalent

[Tgasque308]

Version number of KH Coder

3.03 macOS

Your Qeuestion

Mac OS Sonoma 14.6.1

Your Qeuestion
I prepared data in excel and preprocessed it. Each cell in the source excel file contained several paragraphs, and line breaks associated with paragraphs appear in each cell. However, when I do preprocessing, the counts of paragraphs and H5 are equal. When I examine the txt0.txt file, the paragraph breaks appear as well. So can you help me determine what may be preventing these apparent paragraphs from being counted as distinct?

Screenshots

What language of text are you trying to analyze?
English

[ko-ichi-h]

Can you attach the data file?

It does not have to be an actual data file. Any file that reproduces the problem will suffice.

[ko-ichi-h]

I can't find any line breaks contained within the cell in your CSV file.

Can you tell me which cells contain line breaks?

[Tgasque308]

Well, I am embarrassed because I see that you are correct. However, I am now perplexed that the txt0.txt file that KHCoder generated from the excel sheet has paragraph breaks (attached). So a related question, do you know what hidden characters in a single cell's text would allow for KHCoder to discern paragraph breaks within that single cell? Almost every cell should have paragraph breaks in the version I sent you, but obviously they do not and I understand how that must be related to how I prepared the file and imported the various texts into the cells. The excel organization seemed to me to be the easier way to prep data—especially for other potential uses--but maybe I should have taken the time the first time around to prepare txt files. Do you recommend this as the better way? Thank you so much (for your responsiveness and designing this great tool), Tom Smith Charleston, SC, USA

…

On Apr 18, 2025, at 9:32 AM, ko-ichi-h ***@***.***> wrote: I can't find any line breaks contained within the cell in your CSV file. Can you tell me which cells contain line breaks? — Reply to this email directly, view it on GitHub <#1331 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BRTUFJCOEE5DJAAONMGTF7D22D5IHAVCNFSM6AAAAAB3MHRGAOVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEOBXHAZTKNY>. You are receiving this because you authored the thread.

[ko-ichi-h]

It's not embarrassing at all to make mistakes and learn new things.

Anyway, your current approach looks nice to me. I think using Excel and trying several variables like '5 yr' and '3 yr' is a very good approach.

I'm not sure if this will be helpful, but here's some information about line breaks. If you want to insert a line break within a cell in Excel, press Alt + Enter (Option + Return on Mac) while editing the cell. When you save the file in CSV format, the line break will be preserved. In the CSV file, the contents of the cell will be enclosed in double quotes, and the normal line break character will appear within those quotes.

Here are some examples:
Anne_partial.xls
Anne_partial.csv

P.S.
If you want to attach files, please open this Discussion page with the web browser. Due to the specifications of GitHub discussions, you cannot attach files when posting a reply to a discussion by email.