Swiss File Knife
a command line
free external tools,
- download the free Swiss File Knife Base from Sourceforge. - open the Windows CMD command line, Mac OS X Terminal or Linux shell. - OS X : type mv sfk-mac-64.exe sfk and chmod +x sfk then ./sfk - Linux: type mv sfk-linux-64.exe sfk and chmod +x sfk then ./sfk OS X and Linux syntax may differ, check the help within the tool.
sfk tabtocsv infile.txt [options] convert plain tab separated data to csv. default input/output format - input fields are separated by a tab and should not be surrounded by quotes, as these are not interpreted. input fields themselves cannot contain TAB characters. - output fields are separated by comma "," - output fields are surrounded by quotes " if input contains a comma or quote - if input contains quotes it is escaped as "" options -tofile x write output to file x -quotetext surround all text by quotes -quoteall surround all output by quotes -outsep="x" change output separator to character x, e.g. ; or \t -quote="x" change quote character web reference http://stahlworks.com/sfk-tabtocsv examples sfk tabtocsv in.txt -tofile out.csv convert tab separated to csv in default format sfk csvtotab -quote="\x27" -insep=";" in.csv -tofile tmp.tsv reads a CSV with input fields separated by semicolon and surrounded by single quotes ' with ASCII code hex 27 sfk tabtocsv -outsep=";" -quote="\x27" tmp.tsv -tofile out.csv converts tab separated to an output CSV, with output fields separated by semicolon and surrounded by single quotes
sfk is a free open-source tool, running instantly without installation efforts. no DLL's,
no registry changes - just get sfk.exe from the zip package and use it (binaries for
windows, linux and mac are included).
read more about all sfk functions here.