Description: This method is used to remove empty lines from a CSV file. Empty lines constitute those lines that do not have any data between the ",". Blank characters are not considered data. For example, the file before applying this process looks like:
Data1,Data2,Data3,Data4
,, ,
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
After applying this process it looks like:
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
Parameters:
csvRemoveEmptyLines(sInputFile As String, sOutputFile As String) As Long
|
Parameter |
Meaning |
|
sPathOriginal |
CSV file to modify |
|
sPathTarget |
Can be same as sPathOriginal in which case sPathOriginal will be overwritten. If a different name is specified, XLSConverterX will create a new file. |
Return Values:
0: Success
-2: "Unable to open or save to target file. Could be a sharing violation, or invalid file type.
-3: "Unable to open original file. Check file format. Could be a sharing violation.
-201: "Shareware has expired"
Example Code:
Please review the code sample under csvChangeDelimitationCharacter()