|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: |
Dim objFSO, mainFile, newFile, i, strMainFilePath, strNewFilePath
'************************************************************************************
'Path to the files. Change them to suit your needs:
'************************************************************************************
strMainFilePath = "source.txt"
strNewFilePath = "dest.txt"
'************************************************************************************
'Create a File System Object to manipulate files:
'************************************************************************************
Set objFSO = CreateObject("Scripting.FileSystemObject")
'************************************************************************************
'Now as objFSO is created, open the source text file:
'************************************************************************************
Set mainFile = objFSO.OpenTextFile(strMainFilePath, 1)
Set newFile = objFSO.CreateTextFile(strNewFilePath, True)
'************************************************************************************
'Error Checking:
'************************************************************************************
On Error Resume Next
'************************************************************************************
'Write the first 10 lines from source.txt to dest.txt: (dest.txt: lines 1-10)
'************************************************************************************
For i = 0 to 9
newFile.WriteLine(mainFile.ReadLine)
Next
'************************************************************************************
'Close dest.txt:
'************************************************************************************
newFile.close
'************************************************************************************
'Create file temp.txt:
'************************************************************************************
set tmpFile = objFSO.CreateTextFile("temp.txt", True)
'************************************************************************************
'Write lines 11 onwards in file source.txt to temp.txt: (temp.txt: lines 11 onwards)
'************************************************************************************
do until mainfile.AtEndofStream
tmpFile.WriteLine(mainFile.ReadLine)
loop
'************************************************************************************
'Close source.txt and temp.txt:
'************************************************************************************
mainFile.Close
tmpFile.Close
'************************************************************************************
'Replace current source.txt with temp.txt, which contains 10 rows less.
'************************************************************************************
objFSO.DeleteFile(strMainFilePath)
objFSO.MoveFile "temp.txt", strMainFilePath
'************************************************************************************
'Now, before using dest.txt, clean it to ensure no blank lines or blank spaces:
'************************************************************************************
Const ForReading = 1
Const ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set newfile = objFSO.OpenTextFile("dest.txt", ForReading)
Do Until newfile.AtEndOfStream
strLine = newfile.Readline
strLine = Trim(strLine)
If Len(strLine) > 0 Then
strNewContents = strNewContents & strLine & vbCrLf
End If
Loop
newfile.Close
Set newfile = objFSO.OpenTextFile("dest.txt", ForWriting)
newfile.Write strNewContents
newfile.Close
'************************************************************************************
'If the last 2 chars of the dest.txt file is a carriage return, remove it:
'************************************************************************************
Set newFile = objFSO.OpenTextFile("dest.txt", ForReading)
strFile = newFile.ReadAll
newFile.Close
intLength = Len(strFile)
strEnd = Right(strFile, 2)
If strEnd = vbCrLf Then
strFile = Left(strFile, intLength - 2)
Set newFile = objFSO.OpenTextFile("dest.txt", ForWriting)
newFile.Write strFile
newFile.Close
End If
|
Advertisement
| Hall of Fame |