Copy as TSV omits Path column and exports Name as full path

[David.P]

Hello Forum,

I hope it's okay if I post the below conversation held via email due to a glitch in the forum that seems to have been resolved now.

Cited from the conversation below:

Could you please check whether Copy as TSV is currently using a different internal property list, or whether the Path column is being skipped accidentally?

I'm not sure how to do/check that. Could you please elaborate?

From the Bookmarks menu, click Add to bookmarks...

The bookmarks variant works and does copy name and path separately as intended.

Thanks for looking into this!

Kind regards
David.P

----- Original Message -----
[...]

Sorry about the 403 error. [...] The forum should be back up now. Please feel free to make a post.

Could you please check whether Copy as TSV is currently using a different internal property list, or whether the Path column is being skipped accidentally?

Everything has always copied the Full filename (never Name + Path separately)

If you would like to copy: "Name, Extension, Date Modified, Size, Path and Authors", please try the following:
From the Bookmarks menu, click Add to bookmarks...
Change the Name to:
Copy Name, Extension, Date Modified, Size, Path and Authors

Change the Search to:
/copy $Name:&tab:$Extension:&tab:$Date-Modified:&tab:$Size:&tab:$Path:&tab:$Authors:

Optionally bind a keyboard shortcut.
Click OK.

[...]

----- Original Message -----
Hi,

I'm getting this error message when trying to reply to a thread or creating a new thread.
Error 403 Forbidden [...]

I was going to post the following:

I think I may have found a small regression in the current Everything 1.5 Alpha/Beta.

I am using:
File -> Copy Property -> Copy as TSV

I have set these columns to visible:

image.png (28.54 KiB) Viewed 201 times

This would be the expected TSV output:

Code: Select all

Name <TAB> Extension <TAB> Date Modified <TAB> Size <TAB> Path <TAB> Authors

This is the actual TSV output that I get:

Code: Select all

Full path including filename <TAB> Extension <TAB> Date Modified <TAB> Size <TAB> Authors

So the "Path" column is omitted in the TSV output, and the "Name" column is exported as the full path including the filename.

Example actual output:

Code: Select all

C:\Users\[username]\Downloads\US123456789.pdf <TAB> pdf <TAB> 2026-05-17 10:39:35 <TAB> 3495859 <TAB> [Some Autor]
C:\Users\[username]\Downloads\US987654321.pdf <TAB> pdf <TAB> 2026-05-15 11:20:32 <TAB> 2692002 <TAB> [Some Autor]

I seem to remember that this same workflow DID copy Name and Path separately to TSV last week.

Could you please check whether Copy as TSV is currently using a different internal property list, or whether the Path column is being skipped accidentally?

Thanks!

[therube]

If I "run",

/copy $Name:&tab:$Extension:&tab:$Date-Modified:&tab:$Size:&tab:$Path:

directly from the searchbar, I get:

Code: Select all

03_lastfm.luac	luac	132685088330000000	1700	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art
02_frenchtv.luac	luac	132685088330000000	4437	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art
01_googleimage.luac	luac	132685088330000000	1502	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art
03_lastfm.luac	luac	132102750250000000	1640	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art
02_frenchtv.luac	luac	132102750250000000	4377	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art
01_googleimage.luac	luac	132102750250000000	1442	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art
308.sha11	sha11	133113141731758909	639	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308
308.sha1	sha1	133113166228800060	691	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308
67AB4FD364AE1CFE3842CADA44484F62		132819701827916434	22	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy (2)\watch_later
4AE519867E386BAADFC2C0D3CEE8D0A8		132819701827756424	121	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy (2)\watch_later
413F928A75256AEF1C7EBD015BEFDD5F		132674562782917725	107	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy\watch_later
67AB4FD364AE1CFE3842CADA44484F62		132674562782927726	22	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy\watch_later
81959B02A02A6963DA6D92FB9FD5764A		132826015235234048	37	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x
533F7361D0F3AEF21541E0CB2E07254C		132826015235234048	28	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x
67AB4FD364AE1CFE3842CADA44484F62		132826027824694124	22	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x
021A3A9F6D4EE65548DC74E9C521B276		132826015235224047	51	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x
2A496547338D5F96817A632982029DCE		132826015235224047	174	C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x

which appears to be expected results, Path listed separately.



If I,

File | Copy Property

-> Copy as TSV, I get:

Code: Select all

C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art\03_lastfm.luac	1700	2021-06-18 12:53:53	B8B651A2C52DD22458F76B45552CD4ACEAFBD624
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art\02_frenchtv.luac	4437	2021-06-18 12:53:53	78CC5EADAFB11881B3073BF8375D4085A7B04C81
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\lua\meta\art\01_googleimage.luac	1502	2021-06-18 12:53:53	22E831AA077268002F567F8CA729E2081D276D47
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art\03_lastfm.luac	1640	2019-08-14 12:50:25	FA6EDFB2E7E8A8C65EF72CDA4AD67DE3C2FFE0A0
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art\02_frenchtv.luac	4377	2019-08-14 12:50:25	50D8A9E6266909D60A9CB64420C2F03812812FAB
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\lua\meta\art\01_googleimage.luac	1442	2019-08-14 12:50:25	0D3B986BBAEC68923C2AC40C034B46FAD3BB92E6
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\308.sha11	639	2022-10-26 23:16:13	94B997EF1AF0101126BBF9B9DDE4599E71F9798F
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\VLC\308\308.sha1	691	2022-10-26 23:57:02	35E7A0EEB8E1CBD3333FD0C7DACBB89CA5FFA45D
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy (2)\watch_later\67AB4FD364AE1CFE3842CADA44484F62	22	2021-11-21 07:09:42	2CD28BC8E76D208BAC1A5F2BEA65B6FF39634D0F
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy (2)\watch_later\4AE519867E386BAADFC2C0D3CEE8D0A8	121	2021-11-21 07:09:42	0837AB660FFDFB338D1CA551D2C7DDE3023E6742
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy\watch_later\413F928A75256AEF1C7EBD015BEFDD5F	107	2021-06-06 08:31:18	B32AB4B78CE3102FB534A9BDDAC915F4D48427B6
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config - Copy\watch_later\67AB4FD364AE1CFE3842CADA44484F62	22	2021-06-06 08:31:18	2CD28BC8E76D208BAC1A5F2BEA65B6FF39634D0F
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x\81959B02A02A6963DA6D92FB9FD5764A	37	2021-11-28 14:32:03	7C98F345AD033C8557150CB7E8C2B51F7D539EC3
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x\533F7361D0F3AEF21541E0CB2E07254C	28	2021-11-28 14:32:03	B66C6EB05A16CB0D9A72DC1364E71FF23BECCCCD
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x\67AB4FD364AE1CFE3842CADA44484F62	22	2021-11-28 14:53:02	2CD28BC8E76D208BAC1A5F2BEA65B6FF39634D0F
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x\021A3A9F6D4EE65548DC74E9C521B276	51	2021-11-28 14:32:03	A9997FF230B71ED5390CBB0060DE6860EE446999
C:\TMP\KKK\COPY-FFC\WLIB\PLAYERS\mpv.net-AUDIO\portable_config\watch_later.x\2A496547338D5F96817A632982029DCE	174	2021-11-28 14:32:03	F7D623EDF60623D8C58834679EC7D1975A417B4A

which does combine the path+name?

The items shown under, File | Copy Property, are:
Name, Size, Path, Date Modified, SHA-1 | Copy as TSV

(1412b.
I see the same behaviors in 1409a, in a brand new -instance.)

[tuska]

2David.P
Thanks for sharing! 

I use the code in the bookmark as follows:

Code: Select all

/copy-header Filename&tab:Extension&tab:Date Modified&tab:Size&tab:Path:
/copy $Name:&tab:$Extension:&tab:<FORMATFILETIME:$dm:>&tab:$Size:&tab:$Path:
/comment - /copy $Name:&tab:$Extension:&tab:$Date-Modified:&tab:$Size:&tab:$Path:  (Tab separated - TSV)
/comment - https://www.voidtools.com/forum/viewtopic.php?t=17687 Copy as TSV omits Path column and exports Name as full path

Keyboard shortcut: CTRL+ALT+T

Using

<FORMATFILETIME:$dm:>

, I was able to display the 'Date-Modified' as follows:

DD.MM.YYYY HH:MM

(German).

Command IDs
/command 41183   RESULT_LIST_COPY_TSV_WITH_HEADER
/command 41185   RESULT_LIST_COPY_CSV_WITH_HEADER
/command 41067   Copy as CSV - WITH HEADER
/command 41096   Copy as TSV - WITH HEADER

[David.P]

I use the code in the bookmark as follows:

Yes, the bookmark works:

The bookmarks variant works and does copy name and path separately as intended.

But why does

File -> Copy Property -> Copy as TSV

not seem to work as intended?:

This would be the expected TSV output:

Code: Select all

Name <TAB> Extension <TAB> Date Modified <TAB> Size <TAB> Path <TAB> Authors

This is the actual TSV output that I get:

Code: Select all

Full path including filename <TAB> Extension <TAB> Date Modified <TAB> Size <TAB> Authors

[tuska]

But why does

File -> Copy Property -> Copy as TSV

not seem to work as intended?:

I suspect that this command is being used here:
/command 41183  "UI_ID_FILE_COPY_TSV_WITH_HEADER"
and works as designed.

[void]

This would be the expected TSV output:

Name <TAB> Extension <TAB> Date Modified <TAB> Size <TAB> Path <TAB> Authors

I agree, I will add a copy_as_tsv_filename option and have it disabled by default.
Everything shouldn't be smart here and just copy your values as they are displayed. (as expected)

[David.P]

Thanks @tuska and @void!

I was just going to share the bookmark code that has been working for me, in the meantime. This code copies the header names as well and, for some reason, copies the 'Date Modified' in a format that seems to be better recognized by Excel when pasting. This is probably similar to what @tuska has been sharing above.

Code: Select all

/copy-header Name&tab:Extension&tab:Date Modified&tab:Size&tab:Path&tab:Authors
/copy $name:&tab:$extension:&tab:<FORMATFILETIME:$date-modified:,"dd.MM.yyyy HH:mm">&tab:$size:&tab:$path:&tab:$authors:

[tuska]

This code copies the header names as well and, for some reason, copies the 'Date Modified' in a format
that seems to be better recognized by Excel when pasting.

<FORMATFILETIME:$dm:>

- OR -

<FORMATFILETIME:$date-modified:,"dd.MM.yyyy HH:mm">

With these settings, I get the same results in:
Microsoft® Excel® LTSC MSO (16.0.14334.20688) 64-Bit,
Part of: Microsoft Office LTSC Professional Plus 2021.

I see the advantage of the latter option in the fact that I can easily define the output format myself,
e.g., just

<FORMATFILETIME:$date-modified:,“dd.MM.yyyy”>

, etc.

[void]

Everything 1.5.0.1414b improves copy as TSV.

Copy as TSV will now copy values as displayed.

To copy the filename instead of Name and Path separately:

• In Everything 1.5, from the Tools menu, click Options.
• Click the Advanced tab on the left.
• To the right of Show settings containing, search for:
  tsv
• Select: copy_as_tsv_filename
• Set the value to: true
• Click OK.

copy_as_tsv_filename.



Added the following UI command IDs:

Code: Select all

UI_ID_FILE_COPY_CSV				41067
UI_ID_FILE_COPY_TSV				41096
UI_ID_FILE_COPY_TSV_FILENAME_NO_HEADER		41182
UI_ID_FILE_COPY_TSV_FILENAME_WITH_HEADER	41183
UI_ID_FILE_COPY_CSV_FILENAME_NO_HEADER		41184
UI_ID_FILE_COPY_CSV_FILENAME_WITH_HEADER	41185
UI_ID_FILE_COPY_TSV_NAME_PATH_NO_HEADER		41216
UI_ID_FILE_COPY_TSV_NAME_PATH_WITH_HEADER	41217
UI_ID_FILE_COPY_CSV_NAME_PATH_NO_HEADER		41218
UI_ID_FILE_COPY_CSV_NAME_PATH_WITH_HEADER	41219

UI_ID_FILE_COPY_CSV and UI_ID_FILE_COPY_TSV will use your current settings to determine if the filename or header should be used.

These can be called with /command from a bookmark.