How: search within a file >> create a two column list

English support forum

Moderators: white, Hacker, petermad, Stefan2

Post Reply
User avatar
JimmyTheBroker
Member
Member
Posts: 179
Joined: 2017-06-07, 05:22 UTC

How: search within a file >> create a two column list

Post by *JimmyTheBroker »

Hi guys,

I want to search within a file. and then create a two column list
First column says the location of the file
Second column says the file name and type

eg
F:\WSP - Work\something.docx
F:\WSP - Work\New Folder\something1.docx
F:\WSP - Work\something3.xslx


would become:
F:\WSP - Work\ something.docx
F:\WSP - Work\New Folder\ something1.docx
F:\WSP - Work\ something3.xslx


Thanks guys,

Jimmy
User avatar
sqa_wizard
Power Member
Power Member
Posts: 3862
Joined: 2003-02-06, 11:41 UTC
Location: Germany

Post by *sqa_wizard »

Just create a custom column with:

Code: Select all

[=tc.path]
[=tc.name].[=tc.ext]
Do your search and then just press "Feed to listbox"
Finally apply your just created custom column.
#5767 Personal license
User avatar
JimmyTheBroker
Member
Member
Posts: 179
Joined: 2017-06-07, 05:22 UTC

Post by *JimmyTheBroker »

sqa_wizard wrote:Just create a custom column with:

Code: Select all

[=tc.path]
[=tc.name].[=tc.ext]
Do your search and then just press "Feed to listbox"
Finally apply your just created custom column.

Hi,

I am able to get the custom view: one column of file names, and a second one of their paths. How can I copy these two columns of information into excel?


thanks,
Jimmy
User avatar
Ovg
Power Member
Power Member
Posts: 756
Joined: 2014-01-06, 16:26 UTC

Post by *Ovg »

Copy and paste text below (in code box) into your button bar

Code: Select all

TOTALCMD#BAR#DATA
cm_SaveDetailsToFileW

Wcmicons3.dll,126


0
2044
Click Right Mouse button on created one and change icon and tooltip to your taste.

In Save Dialog name you file as what_you_want.csv
It's impossible to lead us astray for we don't care even to choose the way.
#259941, TC 11.01 x64, Windows 7 SP1 x64
User avatar
Stefan2
Power Member
Power Member
Posts: 4155
Joined: 2007-09-13, 22:20 UTC
Location: Europa

Copy columns to Excel

Post by *Stefan2 »

as alternative you can utilize the TC internal command

cm_CopyFileDetailsToClip=2036;Copy all shown columns



and just paste into Excel. Then in Excel remove column A with the copied default name.ext TC-column.

Excel:

Code: Select all

A                          |  B                    |   C
Name Ext                   |  path                 |   name                              
wcmd_win7amd64_1_eng.inc   |  X:\ToCmd\LANGUAGE\   |   wcmd_win7amd64_1_eng.inc          
wcmd_win7amd64_2_eng.mnu   |  X:\ToCmd\LANGUAGE\   |   wcmd_win7amd64_2_eng.mnu 

Code: Select all

  A                    |  B                           |   C
  path                 |   name                       |
  X:\ToCmd\LANGUAGE\   |   wcmd_win7amd64_1_eng.inc   |
  X:\ToCmd\LANGUAGE\   |   wcmd_win7amd64_2_eng.mnu   |




---

Extra tip:
try "Extended English Menus for Total Commander by petermad"
A alternative menu file which provides all the TC commands, and some more too.
DOWNLOAD from:
http://www.totalcmd.net/authors/1223914.html
http://totalcmd.net/directory/lang.html
http://www.ghisler.ch/board/viewtopic.php?t=33740

Kudos to Peter :thumpsup:




 
User avatar
Dalai
Power Member
Power Member
Posts: 9388
Joined: 2005-01-28, 22:17 UTC
Location: Meiningen (Südthüringen)

Post by *Dalai »

Without the need to create anything, TC already provides this function in the default menus: Mark > Copy to clipboard with all details.

Regards
Dalai
#101164 Personal licence
Ryzen 5 2600, 16 GiB RAM, ASUS Prime X370-A, Win7 x64

Plugins: Services2, Startups, CertificateInfo, SignatureInfo, LineBreakInfo - Download-Mirror
Post Reply