More uses of GnuWin32 / Cygutils tools getclip and putclip using this recipe:
getclip | <command chain> | putclip.
- Copy m'th and n'th column of a table from a browser:
- Copy columns from Excel and replace tab character with space:
tr \t " ".
- Capitalize letters:
tr [:lower:] [:upper:]. (Duh! Enter Shift-F3 in Microsoft Word, thanks to Maria H.).
- Remove indentation from e-mail messages:
sed "s/> //".
- Remove indentation from source code in Word document:
sed -e "s/^ //"(5-May-2008).
- Join lines broken into multiple lines by e-mail clients:
dos2unix | tr -d \n. On a Windows system,
CR-LFpairs for terminating a line, so you have to convert them to a Unix-style
- Another way to join broken lines:
tr -d \r\nusing escape codes for carriage return and line feed, respectively (11-May-2008).
- Remove formatting from string:
getclip | putclip. This is equivalent to Microsoft Word's Paste Special / Unformatted Text. Also to work-around an annoyance in Outlook 2003, were the Edit / Paste Special is disabled when you are responding to an HTML-formatted document (7-May-2008).
- Remove HTML / XML formatting from input:
sed -e "s/<[^>]*>//g"(12-Jun-2008).
A second recipe is
(for /f %i in ('getclip') do @command %i) | putclip if command cannot be used in a pipeline. Two examples are basename (return name of file in a path string) and dirname (return path string without file name).
2008-05-01: Don't simply list transformations and filters that can be done with GnuWin32 tools, but ones where existing applications (e.g. Excel, Firefox, Outlook or Word) don't have an easy way to achieve a particular action.
2012-06-25: Flatten or collapse Excel multi-column data.