Description: This method is used to remove excess commas from a CSV file. Those commas after the last piece of valid data will be removed. 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
Data1,Data2,Data3,Data4
Notice the space character, though not shown in row 2, column 2, is valid data.
Parameters:
csvTrimCSVFile(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()