When a user presses ALT+ENTER in an Excel cell to insert a line break within the cell, this adds a Line Feed character to that cell. However, when the SPC Data Entry module reads the contents of this file - even after the file has been converted to text - it interprets this Line Feed character as the end of a row in the worksheet. (Other programs such as WordPad deal with Line Feed characters the same way.)
GainSeeker provides a utility to remove these Line Feed characters from a file and save it in the same folder as a new file with the ".nlf" file name extension. It does not delete the original Excel file.
This utility is named Txt2Nlf.exe and is installed in the folder where GainSeeker program files (*.exe) exist.
You can use the RUN or RUNANDWAIT template command to launch this utility with the necessary command line parameter.
Required command line parameter
file_path\filename.ext
or
"file path\file name.ext"
Specify the name and location of the file from which to remove Line Feed characters.
If the file path or filename contains a space, the entire path and file name should be surrounded by double-quotes (").
If the file path is not specified, GainSeeker will look for the specified file name in the folder where GainSeeker program files (*.exe) exist.
Examples
TXT2NLF.exe F:\Quality\Data_05172007.tab
This will read the contents of F:\Quality\Data_05172007.tab, strip out the Line Feed characters, and save the results in a file named F:\Quality\Data_05172007.nlf.
TXT2NLF.exe "F:\Quality\My Data.tab"
This will read the contents of F:\Quality\My Data.tab, strip out the Line Feed characters, and save the results in a file named F:\Quality\My Data.nlf.
Sample template formulas
RUNANDWAIT 'TXT2NLF.exe F:\Quality\Data_05172007.tab'
This formula will read the contents of F:\Quality\Data_05172007.tab, strip out the Line Feed characters, and save the results in a file named F:\Quality\Data_05172007.nlf.
RUNANDWAIT 'TXT2NLF.exe "F:\Quality\My Data.tab"'
This formula will read the contents of F:\Quality\My Data.tab, strip out the Line Feed characters, and save the results in a file named F:\Quality\My Data.nlf.
More: