ucan
09-11-2022, 08:36 AM
How to wrap broken lines in one line in a given big text file ?
Example input text file:
1. I'm looking for some vba that will do the . following:*
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
#####
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
#####
----------------------------------------------------------------------------------------above text will be file1 in C:\Temp
2. do the . following: I'm looking for some vba that will
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key
word, and then begin the copy including that
line of key word of text.
4. If same key word is found, the copy should end before that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
----------------------------------------------------------------------------------------above text will be file2 in C:\Temp
3. I'm looking for some vba that will do the . following:
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word,
and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
----------------------------------------------------------------------------------------above text will be file3 in C:\Temp
Example output text file:
1. I'm looking for some vba that will do the . following:* 1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. #####
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ##### ----------------------------------------------------------------------------------------above text will be file1 in C:\Temp
2. do the . following: I'm looking for some vba that will 1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file). 3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. 1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ----------------------------------------------------------------------------------------above text will be file2 in C:\Temp
3. I'm looking for some vba that will do the . following: 1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file). 3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ----------------------------------------------------------------------------------------above text will be file3 in C:\Temp
Example input text file:
1. I'm looking for some vba that will do the . following:*
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
#####
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
#####
----------------------------------------------------------------------------------------above text will be file1 in C:\Temp
2. do the . following: I'm looking for some vba that will
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key
word, and then begin the copy including that
line of key word of text.
4. If same key word is found, the copy should end before that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line,
find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before
that line.
5. After that, the copied text was transferred to a new
text file.
The original file will be located under C:\Temp.
----------------------------------------------------------------------------------------above text will be file2 in C:\Temp
3. I'm looking for some vba that will do the . following:
1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word,
and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before that line.
5. After that, the copied text was transferred to a new text file.
The original file will be located under C:\Temp.
----------------------------------------------------------------------------------------above text will be file3 in C:\Temp
Example output text file:
1. I'm looking for some vba that will do the . following:* 1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. #####
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ##### ----------------------------------------------------------------------------------------above text will be file1 in C:\Temp
2. do the . following: I'm looking for some vba that will 1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file). 3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text.
4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. 1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp.
1. create smaller text files from a larger one 2. I simply require a specific section of the text file (its a log file).
3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ----------------------------------------------------------------------------------------above text will be file2 in C:\Temp
3. I'm looking for some vba that will do the . following: 1. create smaller text files from a larger one
2. I simply require a specific section of the text file (its a log file). 3. The plan is to look for a particular key word in a line, find the key word, and then begin the copy including that line of key word of text. 4. If same key word is found, the copy should end before that line. 5. After that, the copied text was transferred to a new text file. The original file will be located under C:\Temp. ----------------------------------------------------------------------------------------above text will be file3 in C:\Temp