How to do things
AI Noob vs. Pro

List biggest files
List newest files
Show subdir sizes
Search in files
Replace word in files
List dir differences
Send files in LAN

Free Open Source:

Swiss File Knife

a command line
multi function tool.

remove tabs
list dir sizes
find text
filter lines
find in path
collect text
instant ftp or
http server
file transfer
send text
patch text
patch binary
run own cmd
convert crlf
dup file find
md5 lists
fromto clip
hexdump
split files
list latest
compare dirs
save typing
trace http
echo colors
head & tail
dep. listing
find classes
speed shell
zip search
zip dir list

Depeche View
Source Research
First Steps

windows GUI
automation

command line
file encryption

free external tools,
zero install effort,
usb stick compliant:

zip and unzip
diff and merge
reformat xml
reformat source

cpp sources

log tracing
mem tracing
hexdump
using printf

articles

embedded
stat. c array
stat. java array
var. c array
var. java array
view all text
as you type
surf over text
find by click
quick copy
multi view
find nearby
fullscreen
bookmarks
find by path
expressions
location jump
skip accents
clip match
filter lines
edit text
highlight
load filter
hotkey list
receive text
send in C++
send in Java
smooth scroll
touch scroll
fly wxWidgets
fly over Qt
search Java

Convert comma separated .CSV text files to plain tab separated text with the free Swiss File Knife for Windows, Mac OS X and Linux.
  • 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 csvtotab infile.csv [options]

convert csv data to plain tab separated.

default input/output format
- input fields are separated by a comma ","
- input fields can be surrounded by double quotes "
  and may contain escaped double quotes as ""
- output fields are separated by TAB characters
- surrounding quotes are stripped, and escaped
  quotes are reduced to normal quotes
- if input contains any TABs they are changed to
  a single blank character
- input fields cannot contain line breaks

options
  -tofile x     write output to file x
  -insep="x"    set input separator to character x
                e.g. ; or \t
  -outsep="x"   change output separator
  -quote="x"    change quote character, e.g. \x27
                uses single quote.
  -tabrep="x"   change tab replacement character

see also
  sfk ascii     list of ASCII codes for characters
  sfk tabtocsv  further conversion examples

web reference
   http://stahlworks.com/sfk-csvtotab

examples
  sfk csvtotab in.csv -tofile out.txt
     convert to tab separated out.txt
  sfk filter in.csv -+foo +csvtotab
     convert only lines with word "foo"
  sfk csvtotab in.csv +filter "-![warning]"
     drop all lines with [warning] from output
  sfk csvtotab in.csv +view -tab 10
     view in.csv in Depeche View for convenient browse
     and search of contents, with a tab size of 10.
     Within DView press Ctrl+Tab to change tab size
     in small steps, or Ctrl+Shift+Tab for large tabs.
 
sfk csvtotab infile.csv [options]

convert csv data to plain tab separated.

default input/output format
- input fields are separated by a comma ","
- input fields can be surrounded by double 
  quotes " and may contain escaped double
  quotes as ""
- output fields are separated by TAB 
  characters
- surrounding quotes are stripped, and 
  escaped quotes are reduced to normal
  quotes
- if input contains any TABs they are 
  changed to a single blank character
- input fields cannot contain line breaks

options
  -tofile x     write output to file x
  -insep="x"    set input separator to 
                character x e.g. ; or \t
  -outsep="x"   change output separator
  -quote="x"    change quote character, e.g.
                \x27 uses single quote.
  -tabrep="x"   change tab replacement 
                character

see also
  sfk ascii     list of ASCII codes for 
                characters
  sfk tabtocsv  further conversion 
                examples

web reference
   http://stahlworks.com/sfk-csvtotab

examples sfk csvtotab in.csv -tofile out.txt convert to tab separated out.txt sfk filter in.csv -+foo +csvtotab convert only lines with word "foo" sfk csvtotab in.csv +filter "-![warning]" drop all lines with [warning] from output sfk csvtotab in.csv +view -tab 10 view in.csv in Depeche View for convenient browse and search of contents, with a tab size of 10. Within DView press Ctrl+Tab to change tab size in small steps, or Ctrl+Shift+Tab for large tabs.

you are viewing this page in mobile portrait mode with a limited layout. turn your device right, use a desktop browser or buy the sfk e-book for improved reading.

 
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).

 

the Daily Landscape image