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

Search in office files on the command line with the free Open Source tool Swiss File Knife.
  • 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 office file support

sfk can read Open Document Format office files,
which are a standard since 2007, with these
filename extensions:

.docx .dotx .dotm .docb .xlsx .xlsm .xltx .xltm 
.pptx .pptm .potx .potm .ppam .ppsx .ppsm .sldx 
.sldm .odt .ods .odp .odg .odc .odf .odi 
.odm .ott .ots .otp .otg 

sfk can not read older office file formats
like .doc .xls or .ppt.

supported commands:

  sfk olist mydir
     list all office files in folder mydir.

  sfk ofind mydir "/myword/"
     search office and plain text files in mydir
     containing the word 'myword'.

  sfk ofind mydir "/foo*bar/"
     search foo followed by bar in the same line.
     for more infos type: sfk ofind

  sfk ofilter in.xlsx -+foo
     filter content of a spreadsheet table
     for lines containing 'foo'
     for more infos type: sfk ofilter

  sfk oload in.xlsx
     load and display content of in.xlsx

  sfk oload in.xlsx +xex "/*\tapple\t/*"
     find fields containing just 'apple'
     and get the whole row around.

  sfk oload in.xlsx +filt -spat -+\tapple\t
     same as above, using +filter.
     for more infos type: sfk oload

  sfk snapto=alldoc.txt -office mydir
     collect plain text, and text from office
     files like .docx .xlsx .odt .ods,
     from folder mydir into one file alldoc.txt
  sfk find alldoc.txt foo bar
     search alldoc.txt for lines containing
     the words foo and bar
  dview alldoc.txt
     browse and search alldoc.txt interactively
     with the Depeche View text file browser.
     for details see: sfk view

  sfk list mydir +fview -office
     similar to above, view office file contents
     and plain text contents in mydir, all in one
     window using Depeche View (dview.exe)

  dview -office mydir
     same as before, using dview directly.
     for more infos type: sfk view

  sfk unzip in.xlsx -todir tmp
     extract all contents of in.xlsx
     into a folder tmp. -todir is important
     otherwise you end up with many files
     in the current folder.

  sfk zip -rel out.xlsx tmp
     recreate an office file out.xlsx
     from all contents in tmp.
     -rel is important to strip folder
     name 'tmp' from the content filenames.

sfk office file support

sfk can read Open Document Format 
office files, which are a standard since
2007, with these filename
extensions:

.docx .dotx .dotm .docb .xlsx .xlsm .xltx 
.xltm .pptx .pptm .potx .potm .ppam .ppsx
.ppsm .sldx .sldm .odt .ods .odp .odg .odc
.odf .odi .odm .ott .ots .otp .otg

sfk can not read older office file formats
like .doc .xls or .ppt.

supported commands: sfk olist mydir list all office files in folder mydir. sfk ofind mydir "/myword/" search office and plain text files in mydir containing the word 'myword'. sfk ofind mydir "/foo*bar/" search foo followed by bar in the same line. for more infos type: sfk ofind sfk ofilter in.xlsx -+foo filter content of a spreadsheet table for lines containing 'foo' for more infos type: sfk ofilter sfk oload in.xlsx load and display content of in.xlsx sfk oload in.xlsx +xex "/*\tapple\t/*" find fields containing just 'apple' and get the whole row around. sfk oload in.xlsx +filt -spat -+\ tapple\t same as above, using +filter. for more infos type: sfk oload sfk snapto=alldoc.txt -office mydir collect plain text, and text from office files like .docx .xlsx .odt . ods, from folder mydir into one file alldoc.txt sfk find alldoc.txt foo bar search alldoc.txt for lines containing the words foo and bar dview alldoc.txt browse and search alldoc.txt interactively with the Depeche View text file browser. for details see: sfk view sfk list mydir +fview -office similar to above, view office file contents and plain text contents in mydir, all in one window using Depeche View (dview.exe) dview -office mydir same as before, using dview directly. for more infos type: sfk view sfk unzip in.xlsx -todir tmp extract all contents of in.xlsx into a folder tmp. -todir is important otherwise you end up with many files in the current folder. sfk zip -rel out.xlsx tmp recreate an office file out.xlsx from all contents in tmp. -rel is important to strip folder name 'tmp' from the content filenames.

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 Endless Image 🍣 Sushi