ignore paragraphs within text

[caten]

I am trying to export the slideIndex and the notes page ppPlaceholderBody
text from each slide to a text file (following the example here:
http://www.pptfaq.com/FAQ00274.htm) so that I can import the text file into
Excel as 2 columns. I've got the text file exported, but when I import it
into Excel, Excel interprets the paragraph returns WITHIN the notes page
ppPlaceholderBody text as the end of a record (row), which then throws off
the contents of each column.

Is there anything I can do in the text file to prevent Excel from
interpreting every paragraph return as the end of a record? Some way to
encapsulate the ppPlaceholderBody text so that it is treated as a single
entity (with or without paragraphs within)?

Or, is there any way to append the contents of a Print statement immediately
to the end of the previous Print statement contents (ie. NOT use a line
return, so that I can select something else as a record delimiter)?

Any other ideas?

 

[caten]

Thanks for your response. I ended up using an at sign (@) at the end of each
field and a tilde (~) at the beginning of each Print statement so that I
could distinguish those paragraph returns from the paragraph returns within
the notes body text. Then in Word I:
1. Manually removed all record paragraph returns (the ones with a ~ at the
end).
2. Found all <p> (paragaph marks) and replaced with zzz.
3. Found all zzz~ and replaced with <p> (so that now all of the record
paragraph returns are paragraph marks but the paragraphs within the notesbody
text are still zzz.)
4. Converted text to table specifying Other (@) as the field delimiter.
5. Found all zzz and replaced with <p>. (Restoring the paragraphs within the
notesbody).

It's a little convoluted, but it gave me what I need with a minimal amount
of manaul manipulation. Just thought I'd share my results.