Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a text file that contains lots of sentences and
paragraphs. Paragraphs are separated by a "newline". ....however, upon close inspection of the text file with a debugger, each newline character is represented as 3 bytes: 0D 0D 0A in hex, or 13 13 10 in decimal form. Now, suppose I read the entire file into a string variable as follows: Dim s as String s = ReadTextFile("C:\book.txt") ' user defined func() At this point, the string variable "s" contains an entire book of paragraphs separated by 3 bytes equal to 0D 0D 0A. How do I use the Split() function to extract each paragraph? I have tried this code: v = Split(s, vbCrLf) But, it doesn't quite work. Is "vbCrLf" the same as 0D 0D 0A? I'd appreciate any help. Gary, feel free to chime in as well. ;) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Parse Cell Around "Dash" in Data | Excel Programming | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"XML parse error" in Excel 2003 | Excel Programming |