Description: Sometimes unwanted control characters (like carriage returns) can make their way into the data. Use this special process to remove any unwanted control characters. This does not include the carriage return and linefeed at the end of each line of course.
Parameters:
csvRemoveControlCharactersFromFile(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()